Using a Query - Want to find records between a set of dates 1

[usfpjc]

Let's say that I would like to find records that fall between for example between 01/01/01 and 03/30/01 using a query, what type of technique should I use by typing in the query criteria section some type or argument.

Example: [Type date ranges:] between xx/xx/xx and xx/xx/xx

I tried this way but it only works with an expression builder but not with the criteria format.

 

[JJOHNS]

At then end of your query, add a WHERE clause.

WHERE [tblMytable]![MyDate] >= [Forms]![MyForm]![MyDate]
OR [tblMytable]![MyDate] <= [Forms]![MyForm]![MyDate];

You can change the >= and <= to > and < if you don't want the particular dates included.

 

[67peshawar294]

usfpjc,
You need to add brackets to the Between Operator.
In the criteria section of your date field enter;
Between [Enter a date] and [Enter end date]
When you run the query a &quot;Enter Parameter Value&quot; box will appear for Start Date and End Date.