Access Dates

N

NigelBrown

New member
Local time
Today, 18:01
Joined
Aug 15, 2006
Messages
8
Can anyone tell me how to generate a query that shows the results for the 'Last 12 Months" based on a Date field?
 
in the query use the following criteria against the date field:-

>=DateAdd("yyyy",-1,Now())
 
Many thanks Alan, I'll stop scratching my head now :)
 
You must log in or register to reply here.

Similar threads

D
How to select most current date by month, day and year
Replies
15
Views
1,557
Design by Sue
D
J
Date format mm/yyyy
Replies
15
Views
691
JPR
J
C
limit date formula as variable
Replies
16
Views
1,091
MajP
MajP
A
Help with Syntax error
Replies
11
Views
667
The_Doc_Man
The_Doc_Man
E
Solved correct query syntax - (re making the found word appear red colored in report)
Replies
9
Views
495
EdK
E

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom