Access Access Query

Joined
Feb 26, 2013
Messages
12
Reaction score
0
Hi all, I have a table in access called Customer.
I need a query that extracts all data that is ten months old in the Customer table;

The code I have below is as follows;
SELECT *
FROM CUSTOMER
WHERE CUSTOMER.Booking_Date=DateAdd("m",-10,Now());

Essentially I want to only see the data that is ten months old, by subtracting 10 from the current month I should be able to but nothing seems to return.

I have tried the word Date instead of Now with no luck... Any suggestions?
 
Back
Top