Dates (1 Viewer)

[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

 

[Pat Hartman]

The 7 is numeric and therefore should not be enclosed in quotes.

<=Date()-7

 

[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

 

[Pat Hartman]

Your date field must be defined as a text string rather than as a real date/time data type. Make a backup of the table then open it in design view and change the datatype to date/time. If any rows contain invalid dates, their data will be lost - hence the need for a backup. You'll need to fix the bad data manually.

 

[TRWguy]

Thanks

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