Table and Query

[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 DEWEY]

Use the query wizard Find Unmatched using the table and query.

 

[reysmommy]

Use the query wizard Find Unmatched using the table and query.

Hi,

[quoted text clipped - 9 lines]

Thanks!

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.