Retrieve all records 18 mos. prior to date of current order.

[88lbr]

I need a criteria date expression in an Access query to retrieve all orders of a specific product 18 months prior to the date of the current order.

 

[Creepers]

Look at the DateDiff function.