DESPERATELY in need of help on Query last 2 years

[isabel2005]

Hi,

How do I query the last 2 years vs. current date?

Basically, I want to see the record from today date back to 2 years.

Please assist...

Thanks,
Isabel

 

[Mile-O]

By using the DateAdd() function in your query.

 

[mdb4me]

Use the DateAdd and Date functions to specify a period 2 years prior to current date.

SELECT tblItems.Code, tblItems.Item, tblItems.Date, tblItems.Price
FROM tblItems
WHERE (((tblItems.Date) Between DateAdd("yyyy",-2,Date()) And Date()));

 

[isabel2005]

Thank you very much!!!!!!!!!!!!!!!!!!!!!!! Muah!