I'm looking for a way to filter a current query to show only the records in which 2 fields from 1 row equal the value of a field in the previous row.
I'm looking for a way to filter a current query to show only the records in which 2 fields from 1 row equal the value of a field in the previous row.
Cycle trough the rows using DAO or ADO, row by row, comparing the appropriate fields' current row value to the previous row, appending the "ood" current row in a temporary table.