Generate records NOT found

  • Thread starter Thread starter Jason Livengood
  • Start date Start date
J

Jason Livengood

I need to perform a search on about 2000 different
product codes. What would be the best way to do it and is
there any way I could get Access to generate a table of
those records searched that it did NOT find. Any help
provided would be extremely appreciated.

Thank You,
Jason Livengood
 
I need to perform a search on about 2000 different
product codes. What would be the best way to do it and is
there any way I could get Access to generate a table of
those records searched that it did NOT find. Any help
provided would be extremely appreciated.

Thank You,
Jason Livengood

Do you mean that you have about 2000 product codes for which you wish
to search, in a table with a larger number of codes? If so, the best
bet might be to create a Table with the codes for which you're
searching. A Query joining this table to the full product table will
return the matches; you can use the Unmatched Query Wizard to create a
query showing the codes that are not matched.
 
Back
Top