MS Access Data criteria for a specific date

0
votes
< #2/2/2012#

This criteria "Returns items with a date before Feb 2, 2012.".

But how to do so when I run query to enter the date from the keyboard?

Something like this: Enter date:--/--/---- And then return me the dates before the date that I entered.

1
ms-access
You mean, like a parameter query? – Gord Thompson
@Gord Thompson Thank you. This solves the problem. I didn't know that there is such a thing as parameter query. – Fingolfin

1 Answers

0
votes

That is the simple solution thanks to Gord Thompson.

First I set data type to date/time.

Then I made a query with criteria <[Enter date].