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.

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]

As easy as that!

Thanks Phil.