Get Report to show only records in certain date range

J

JudyB

I have a report titled "Closed Jobs". I would like for the user to be able
to type in a date range and see only the closed jobs on the report. I do not
know what code is required to accomplish this task or where to put the code.
Can you provide any assistance. Help is greatly appreciated. I am new to
Access.
 
S

Steve

Presumably you have a jobs table and one of the fields is DateClosed. Create
a query based on this table. Put the following expression in the criteria of
the DateClosed field:
Between [Enter Start Date] And [Enter End Date]

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Record Source not showing field names 4
2 queries, a date range and a report?! 3
Displaying date parameter on a multiple page report 3
Copy previous record into form field 0
Report based on specific dates 6
How to get report to only show <85% 3
report not showing duplicate records 2

Top