CODEWITHSUNDEEP
ms-access
Gopa Soft
Gopa Soft

Reputation: 111

Query to retrieve data of specific date in MSAccess

I want to retrieve of particular date. For example my database has data from 1st-Jan to 31-AUG. I want to fetch data of 1st two months. Please suggest me helping query for this purpose thanks.

Upvotes: 0

Views: 3335

Answers (2)

Alexey
Alexey

Reputation: 683

SQL query: select * from table where table.my_date <= #29/02/2012#

will filter date before 29 feb. In query window you can type <=#29/02/2012#

Upvotes: 0

Fionnuala
Fionnuala

Reputation: 91356

Open the query design window, add your table, double-click fields to add them to the grid. Type a date into the criteria line underneath the date field you added.

Upvotes: 1

Related Questions