Another query - retrieving records?

[MissAnna]

Hi,

I need to retrieve records from a query by date - the criteria is all records for the current month from last year or any year previous to last year ...i.e this month last year or before last year..

Does anybody know what the expression/criteria would be for this?

Thanks to the help of Jon and others the query retrieves records from this month last year..but I also need the years previous to last year...

Thanks!
Anna

 

[Jon K]

Put these in two columns in the query grid:-

Field: Month([nameOfDateField])
Show: uncheck
Criteria: Month(Date())


Field: Year([nameOfDateField])
Show: uncheck
Criteria: <Year(Date())

 

[MissAnna]

Once again, thank you! It works perfectly!

Much appreciated for your assistance, I don't know what I'd do without this site..

Cheers,
Anna