Dates

[TRWguy]

Im sure this is simple but I'm not that good with queries.

I have a table with a bunch of orders from clients, and one of the fields is the date that they ordered the stuff. I need to make a query that finds all orders that are over a week old.

Any Help would be appreciated
Thank You

 

[Howlsta]

Here's a thread for a similar question, which will help you

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30988&highlight=date

Rich

 

[TRWguy]

Rich,

I looked at the thing you sent me and entered this code <=Date()-"7" into the criteria section under the Field Date, but it doesn't work the query still gives me all the entries in my table instead of the ones im looking for.

If you could tell me if my code is wrong or im doing something else wrong your help would be appreciated.

Thank you

 

[TRWguy]

When I enter the expression in, it automatically adds the quotes and wont let me take them out do you know how

Thank You

 

[TRWguy]

Thanks

Thank You Pat, you were right, that fixed all my problems