Query bringing up last 14 days

[stevoreeno]

I know you probably get this one all the time, but I need to know what I can put in the criteria of a query that will bring up dates from 14 days ago to the current.

 

[scriverb]

Use the following as a model for your query:
Select *
FROM YourTableName as A
WHERE A.[DateField] >= DateAdd("d", -14, Date()));

Just update the the table name and Date Field Name.

Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[stevoreeno]

Where does that go into this expression?

SELECT Hours.FristLast, Hours.Hours_Spent, Hours.Date, Hours.Project, Hours.Type
FROM Hours
WHERE (((Hours.Type)="over-time&quot)

 

[scriverb]

I think this should do it:

SELECT Hours.FristLast, Hours.Hours_Spent, Hours.Date, Hours.Project, Hours.Type
FROM Hours
WHERE (Hours.Date)>= DateAdd("d", -14, Date());

I assumed the field that you wanted to perform the criteria select on was Hours.Date.



Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???