Query Criteria - Date range

[pjdrury]

Hi.

I want to set up a simple query criteria where it searches based upon a column called Date.

So I want a criteria that says when you run the query ...

Between which date range? And which date?

Now I know I need to use Between and And within the Citeria, however I would be grateful for someone to show me the exact wording for the criteria.

Thanks and kind regards.

Phil Drury.

 

[rainman89]

First of all. do not use Date as a column name as it is a reserved word. change it to mydate or something along those lines
as for the query criteria it would be

BETWEEN [startdate] AND [endDate]

if you were entering the dates on a form it would be

BETWEEN forms!formname.[startdate] AND forms!formname.[endDate]

 

[pjdrury]

Cheers Ray!

As easy as that!

Thanks Phil.