Report Help

[Abarency]

First I'm new to access so take it easy.



I have a db with multiple tables. I have a table with a list of vehicles that always stays the same. In another table there are multiple dates that those vehicles were inspected. I need a report to show the inspection dates. Sounds easy and it is. I have a report that does just that. What it doesn't show is the vehicles that don't have an inspection. That's the problem. The report needs to show every vehicle and the inspection date within a set of date parameters.

[June7]

What you could show is every vehicle and the latest inspection date for each. As soon as you apply a date range criteria, records will be filtered out.

[Abarency]

That would work perfect. I have made some progress and have added a parameter to my query which works fine but doesn't show vehicles that have not received an inspection within that date range.

[June7]

And that is the way filters are supposed to work. I don't understand the confusion.