importing records based on an IF calc/formula?

[Tegan Northwood]

can a conditional import of records be done?

I have two lists - I need one table to import records from the other table only if the records aren't already there. I am trying to separate a list of people who have responded to a survey from a list of all people surveyed in total - in other words, I am trying to identify the 'no''s in the survey (who haven't responded) so that they can be grouped.

I originally had two lists in Excel, and am converting both to Access - the 'yes' people will have a checkbox ticked. So I am hoping I can get that table to import only the records from the 'total surveyed' table, leaving those records with a blank checkbox. I am trying to figure it out but in the meantime does someone know the quick answer?

 

[scottfarcus]

Quick answer would be to import everything, then run a delete query to remove the records that don't match your criteria.