Table and Query

  • Thread starter Thread starter reysmommy
  • Start date Start date
R

reysmommy

Hi,

I want to create a query that would look at the table, and see which records
are not in the query, and display them in another query.

Table A = msd
Query A = records extracted from msd, distinct records
Query B = records from msd that are not in Query A


How can I do this? This table was not well created, and doesn't have a unique
id or primary key.

Thanks!
 
KARL said:
Use the query wizard Find Unmatched using the table and query.
Hi,
Click to expand...
[quoted text clipped - 9 lines]
Thanks!
Click to expand...
Click to expand...

Thank you, but that was an option I tried and it worked for the tables that
had primary keys, but not for the ones without a unique ID.

I found a solution! I will post it here in case somebody can benefit from it.

I did the following:

SELECT DISTINCT * INTO MSDNODUPS
FROM MSD;


This extracts all distinct records into a new table, leaving behind the
duplicates.
 
Back
Top