Prompt for dates for query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
 
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)
 
Back
Top