Dates - Between first and last in query/report

J

jwr

I am attempting to create a report that First has a box that pops up and ask
for the beginning and ending date and then the report appears with the info.

How do I do this?? I may want the report for an entire month or for a range
of dates.

Thanks in advance for your help.
JR
 
J

John Vinson

I am attempting to create a report that First has a box that pops up and ask
for the beginning and ending date and then the report appears with the info.

How do I do this?? I may want the report for an entire month or for a range
of dates.

Thanks in advance for your help.
JR
Click to expand...

Base the Report on a query with

BETWEEN [Enter start date:] AND [Enter end date:]

as a criterion on the date field.

John W. Vinson[MVP]
 
J

jwr

Thank you. One more question: How do I get this date range to print on the
report?

John Vinson said:
I am attempting to create a report that First has a box that pops up and ask
for the beginning and ending date and then the report appears with the info.

How do I do this?? I may want the report for an entire month or for a range
of dates.

Thanks in advance for your help.
JR
Click to expand...

Base the Report on a query with

BETWEEN [Enter start date:] AND [Enter end date:]

as a criterion on the date field.

John W. Vinson[MVP]
Click to expand...
 
J

John Vinson

Thank you. One more question: How do I get this date range to print on the
report?
Click to expand...

Simply set the control sources of two textboxes on the report to the
prompts:

= [Enter start date:]

for example.

John W. Vinson[MVP]
 
Top