Queries (Older than X date) (1 Viewer)

[kacey8]

Hi All,

I currently have a query set up which responds and filters by the date.

I use the current code in the criteria on the query for todays date less 7 days

DateAdd("d",-7,Date())

This works perfectly and I had no problem with it. However I need to adjust the criteria so it is less than 7days ago OR OLDER....

How would I go about doing that?

 

[pr2-eugin]

Put a less than sign in front of the DateAdd function like.

< DateAdd("d", -7, Date())

 

[kacey8]

He Shoots, He Scores and by golly that was the quickest reply I have ever seen

 

[pr2-eugin]

Ha Ha ! You're welcome. Glad to be of help !

 

[kacey8]

tbh with the amount I have been using access enough I should've known it :/