Query by month

[Mellstock]

Is there a way to query by month. For example show me all the invoices
for work carried out in November 2006 or any other month for that
matter.

Currently I am using a parameter query and entering a start and a
finish date.

Thank you

 

[Ken Snell \(MVP\)]

How do you want to identify a month -- by name only, by a month and year,
etc.?

Assuming that you want a month and year, one "easy" way of doing this is a
query that looks like this:

SELECT * FROM TableName
WHERE Month([DateFieldName]) = [Enter month number:] AND
Year([DateFieldName]) = [Enter year (yyyy):];