Bookmark page
Printable version
Course updates
|
RSS feeds
Hints and tips home » Access hints and tips » How To Find All Overdue Accounts?
How To Find All Overdue Accounts?
To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:
1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:
<Date()
This filter returns records where the Invoice Date is before today's date.
This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:
<Date()-15
This filter returns records where the Invoice Date is 15 days before today's date.
Added by Carlos on 25th October 2006
More Access hints and tips, like:
 |
|
» Forum post: Resource shedule |
Shared resource schedule and how to see if there is an excess of claim against those resources. Or even that sub projects can see how much labour has been claimed against that pool.
