Prompt for dates for query

[Guest]

I know how to use a form to prompt for user parameters for a report that is
executed from a command button on the main screen (executable). However can
I, and how, us a form, or a prompt of some sort to have the user enter two
dates, that then feed to the query and execute it? From there the user will
save the results as a *.csv file.

 

[Lynn Trapp]

Add something like this to the query behind your report:

WHERE YourTableDatefield >= Forms!YourForm!YourBeginningDate AND
YourTableDateField <= Forms!YourForm!YourEndingDate

I know how to use a form to prompt for user parameters for a report that is
executed from a command button on the main screen (executable). However can
I, and how, us a form, or a prompt of some sort to have the user enter two
dates, that then feed to the query and execute it? From there the user will
save the results as a *.csv file.

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com

 

[Steve]

Put the following expression in the criteria of your date field:
Between [Enter Beginning Date] And [Enter Ending Date]

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