Query for the last ** days

[kp1279]

I want to set up a simple query, which will bring back the results from a table for the last amount of days.

i.e. the records inputted in the last 5 days etc.

I have tried in the query criteria:

day()-5

This just brings back though any date with a 5 in???

Any help apreciated.

 

[ZmrAbdulla]

Between Date() And Date()-5

hope this helps

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[kp1279]

Worked a treat

Many thanks.

KP