Query by month

  • Thread starter Thread starter Mellstock
  • Start date Start date
M

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
 
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):];
 
Back
Top