Query with Input Box

  • Thread starter Thread starter Rica
  • Start date Start date
R

Rica

I have a query, which works fine with the criteria in the
date field written manually. But since I don't want the
client to go to the code and write down the date, rather
just have an Input Box asking for the date and have the
query running. Can anyone suggest how it can be done??
Since I do this with the report but couldn't figure it out
with the query. I would appreciate any help in this
matter. Thanks in advance.
 
Rica,
Instead of having the criteria written as something like:
9/1/2003
Click to expand...
Write, on the DateField criteria line:
[Enter the Date]
Click to expand...

Or, if you wish to return records between certain dates:
Between [Enter From Date] AND [Enter To Date]

The user will be prompted for the dates.
 
Back
Top