I have a report that I am trying to develop that returns a log of inspections. The user wants the report to return records where a second inspection has not been done. I have the following fields:
Cycle-indicates what number inspection has been done. All the inspections that were done the first time have a "1". All the records that have been done a second time have a "2".
So somehow I need to write the query or build the report to return only those records where there is only one record initially. For the future though the report or query should return those records were there are only 1s and 2s but not a 3. That could be built into a parameter somehow where the user puts the last finished cycle number.
Any help would be greatly appreciated.