criteria dates

[mon]

Hi, I would like to make a query where the user puts in
beginning date and end dates for the query
Thanks
Monika

 

[Gina]

In the criteria field of the date type:

Between Date() and Date()

 

[Sambantham Kuppusamy]

Monica,

In the query put some user variables in the where (Criteria) like this:
Between [form1]!Date1 and [form1]!Date2

So when the user runs the query it will pop up 2 dialog boxes for date1 and
date2. These will be filtered and you will get only required rows.


SAM

 

[Fredg]

Monika,

If you are not using a form to enter query parameters, then,
In the Date field's criteria line, write:
Between [Start Date] and [End Date]

When the query is run, a parameter box will ask
for each date.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
Remove nothing from my address

 

[mon]

Thanks all - it's working. How do I do it if I use a
form???

 

[Fredg]

Change the query criteria to:

Between forms!FormName!StartControlName and forms!FormName!EndControlName

The form must be open when the query is run.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
Remove nothing from my address