Report problem

[awilko1]

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.

Any help would be excellent

 

[T.Smith]

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