Created a report which shows inspections carried out per week per item. I want seperate report to show inspections due which I have filtered no problem but it is showing all records per item. How do I filter out the old records and show only last entry which has expired etc.
:confused:
Any help would be excellent

Use a query as a record source for your report. With a query you can use "expressions" to filter records as needed. You can find examples of query criteria in your access help.

Toby