Date In Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SeanE - 26 Mar 2006 23:48 GMT

I have a query that shows me all my suppliers, 1 of the fields shows the due
date of the item. i would like to run the query showing me all over due
orders, which are more than 2 weeks older than todays date, i don't want he
user to enter todays date but access to take todays date - 14 days and show
everyitem that is older.

ie todays date 25/03/2006 - 14days = show all orders older than 11/03/2006
Hope this makes sense
Thanks
Sean

Reply to this Message

Tom Ellison - 27 Mar 2006 00:06 GMT

Dear Sean:

Assuming the table Orders contains only unfilled orders, perhaps this might
be close:

SELECT OrderNumber, Supplier, OrderDate
FROM Orders
WHERE OrderDate <= Date() - 14

I have made a huge number of assumptions about table and column names and
which orders are yet unfilled.

If you give more details, I would need to make few if any assumptions. So,
good luck with this.

Tom Ellison

>I have a query that shows me all my suppliers, 1 of the fields shows the
>due
[quoted text clipped - 9 lines]
> Thanks
> Sean

Reply to this Message

Jerry Whittle - 27 Mar 2006 00:07 GMT

Put the following in the criteria of your date field:

< Date() - 14

Signature

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> I have a query that shows me all my suppliers, 1 of the fields shows the due
> date of the item. i would like to run the query showing me all over due
[quoted text clipped - 6 lines]
> Thanks
> Sean

Reply to this Message