EXCEPT

Example
SELECT column_name1, column_name2, ...
FROM table_name1
EXCEPT
SELECT column_name1, column_name2, ...
FROM table_name2;

Hi, Thanks for the response, but i'm not sure i follow the logic. I do not know of a way to identify the first 7 records that should be excluded.

Might need an ORDER BY in there, Alex.

Also, Alex, are you suggesting to copy data to a second table?

The example was just the syntax of how to use EXCEPT
Is just SET Theory.

Alternate example
SELECT *
FROM myTable x
WHERE x.ID NOT IN (SELECT Top 10 id FROM myTable ORDER BY ....)
ORDER BY ...

Hi Nathan, the top 7 records in the first part of the query are not the same top 7 records in the second part because one has the WHERE condition and the other doesn't.  The second part of the query should be:

    SELECT TOP 7 RiskItems.strPolicyNumber From RiskItems
    WHERE RiskItems.strPolicyNumber=[Forms]![frmPropertyRenewalPopUp]![fldPolicyNumber]

They have to have matching WHERE conditions.

And of course if the WHERE condition results in few than 7 records you won't see anything.