Dates - Between first and last in query/report

  • Thread starter Thread starter jwr
  • Start date Start date
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
 
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

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]
 
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

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]
 
Thank you. One more question: How do I get this date range to print on the
report?

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

= [Enter start date:]

for example.

John W. Vinson[MVP]
 

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

Back
Top