Only want to pull current records on report

[JSD]

Hello

I have a 'tblGaugeDirectory' related to a 'tblInspectionHistory.' For each gauge in the directory, there may be many inspections. I can see these inspections by hitting the filter in the 'tblGaugeDirectory', but I only want to pull the most recent one onto the report, perhaps by using the 'InspectionDate' column.
Right now the report is bound to a query that is simply pulling all the gauge info from the 'tblGaugeDirectory' and all the inspection info from the 'tblInspectionHistory,' but when I run the query I lose the filter and it lists each inspection as its own record (same on the report). Could you also give me a hint on how to list all of these inspections under one line of gauge info? Many thanks...

Jeremy

 

[dynamictiger]

You could try the grouping function in the query and simply set the inspection field to max.