I have a form with two subforms on it and I am having problems with the SQL record source for the second subform. In the first subform I have SQL that selects the top value in field2 that also matches the value in field1. In the second subform I need to select all of the remaining records. So really, I need to invert the selection from the first subform. How could I go about this?
SQL on subform
- Thread starter jwleonard
- Start date
