This shouldnt be hard.

petercummins

Registered User.
Local time
Today, 19:41
Joined
Sep 6, 2005
Messages
52
I need a query that will return values of a customer number that have been created within the last week.

There is a customer_code field and a date_created field.

Any help would be appreciated.
 
In the date_created field criteria put this

Code:
Between Date()-7 and Date()

Col
 
Cheers,

Just found out that this also worked: -

>=DateAdd("d",-7,Date())
 
Yes, there's 2 or 3 ways of doing it.

Col
 
Wot would the code be if you wanted to know the date of all customer_codes created over a week ago. In other words not in the last 7 days?
 
Cheers guys! Its been since school since I last worked with Access.
 

Users who are viewing this thread

Back
Top Bottom