RecordID - Auto number
FileNumber - Numeric String
Validated - Boolean
I need to write a query to select the count of file numbers that were not validated i.e where Validated=False.
The trick is that there are could be multiple records for the same file number. And if a file number has a record where Validated=True it does not need to be counted. For example: