Daily report
SELECT Field1, Field2, ..., FieldN
FROM TableName
WHERE DateField = #MM/dd/yyyy#
Weekly report:
SELECT Field1, Field2, ..., FieldN
FROM TableName
WHERE DateField BETWEEN #MM/dd/yyyy# AND DateAdd('ww', -1, #MM/dd/yyyy#)
Monthly report:
SELECT Field1, Field2, ..., FieldN
FROM TableName
WHERE DateField BETWEEN #MM/dd/yyyy# AND DateAdd('m', -1, #MM/dd/yyyy#)
Yearly report:
SELECT Field1, Field2, ..., FieldN
FROM TableName
WHERE DateField BETWEEN #MM/dd/yyyy# AND DateAdd('yyyy', -1, #MM/dd/yyyy#)
For further information, please see:
http://www.techonthenet.com/access/functions/date/dateadd.php[
^]