Creating a Report with Date Restrictions

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

Ok The problem starts off with my 2 tables. One has
employee information like name and ID number and the other
has training information such as what you were trained in
and etc. The training information has a column for the
date they were trained. I need to know how to create a
report so that when you click on the report it pops up
with a form asking for the time period you would like to
know what training has gone on like if someone wanted to
know who was trained in what for 2004 they would type
1/1/2004 in begining date and 12/31/2004 in the ending
date then all trainging information between those dates
would pop up.

Thanks
Terry
 
If you build this in query builder,
add the tables you desire and pull the fields you need. in the 'date' field
criteria enter:

between [StartDate] and [EndDate]

When you run the query, it will ask you for the values and will pull all
record which fit the criteria.
 
Back
Top