I am very new to this...both Access and posting a request for help. Please forgive my shortcomings. http://www.access-programmers.co.uk/ubb/smile.gif

I am trying to create a query that will show me invoices that are 30 to 60 days overdue.

I've tried many things and read all the help files I could find on date topics before coming here and I did try to search the archives here before posting.

Nothing I've tried seems to work....I've tried so many things, I can't remember all I've tried so far.

Any suggestions would be very much appreciated.

[This message has been edited by DeeBee (edited 02-08-2002).]

[This message has been edited by DeeBee (edited 02-08-2002).]

[This message has been edited by DeeBee (edited 02-08-2002).]

The following will retrieve all invoices dated more than 29 days ago.
Select ...
From YourTable
Where InvoiceDt < DateAdd("d",-29,Date());

If you really want to limit the range on both ends, change the Where clause to:
Where InvoiceDt Between DateAdd("d",-30,Date()) and DateAdd("d",-60,Date());

Or even more simple...

SELECT Invoices.InvoiceId, Invoices.DueDate
FROM Invoices
WHERE Invoices.DueDate BETWEEN Date()-30
AND Date()-60;

[This message has been edited by RV (edited 02-08-2002).]