Date countdown

[Breezer]

I am designing a database that shows a table of customers who get the products on tab. After 30 days they should have paid, but most do not and this drags on for 45 - 60 days. How would I best design the database to show the customers who have expired the 30 day limit so they could be chased up?

Thanks in advance for all replies

 

[Mile-O]

Use the DateAdd() function in a query criteria.


i.e.

>=DateAdd("d", 30, [YourField])

 

[Breezer]

wow!, that was quick!

okay, so the database would have to open and run as a query each time?

 

[Breezer]

Great, got it to work...thanks alot Mile-O-Phile