I have three fields I'm filtering on a tabular form.
If I come up with 10 matches but in 5 of the records all three fields are equal. I would want to display the 5 records that are not equal and only one from the 5 that are equal.
I would build an underlying select query that groups on field 1, 2, and 3 and either counts or selects the min or selects the max of Record# field, and then use the query as my datasource for the form. This would work if you are filtering on field 1, 2, or 3, but not if you wanted to filter based upon the Record# field.