exclude recordset results from another recordset
Posted: Sun Jun 21, 2009 3:03 pm
I am trying to exclude the results of one recordset from a second recordset.
1st recordset pulls all categories from a table that match a specific criteria.
2nd recordset pulls all categories from the same table, but if these categories have appeared in the 1st recordset, I don't want them returned.
I'm not having any luck figuring out how to set this up. Any help would be greatly appreciated.
Thanks in advance!
1st recordset pulls all categories from a table that match a specific criteria.
2nd recordset pulls all categories from the same table, but if these categories have appeared in the 1st recordset, I don't want them returned.
I'm not having any luck figuring out how to set this up. Any help would be greatly appreciated.
Thanks in advance!