Query by month

hello evreyone

i have a query includes a date column ..my exactly question is how can i make filtering on the date data in any month i want by ignore the days like this (12/2004) without (01/12/2004)?

thanks beforehand

Hi khalili,

In your query, create an expression for your date field to show by month/year. For example if your query contains the table Orders and the date field was named OrderDate, then your expression would look like this:

Expr1: Format([Orders]![OrderDate],"mm" & "/" & "yyyy")

Then for your criteria/filter you would enter "12/2004" and that would return all records for the month of December in the year 2004.

lwells

hi lewlls;

i do this way befor but in little difference that i make a 2 expression one for the year and the author one for the month and this way had to be caused that i need 2 textbox in the form ;but your way is really amazing me

great lewlls and thanx