Infero Training – Business and Technical Courses

Credit control is very important for every business. How Microsoft Access can help you to find all overdue accounts?

Let’s say you have a table in Microsoft Access with your Customer names and Invoice date:

Your invoices should be paid within 30 days of issue. In order to find overdue accounts you can create a filter that compares today’s date with the Invoice Date in the table.

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter <Date()-30

After running the query you will receive records for customers, where the Invoice Date is 30 days before today’s date.