- 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?
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?