Manick Solutions

Access criteria expressions

http://office.microsoft.com/en-us/access-help/examples-of-query-criteria-HA010066611.aspx

Very useful list of query criteria expressions for retrieving records by date:

e.g. last week, last month, last 28 days