Newbie Question 1

[owens2024]

Okay so I'm new to this Access stuff... so go easy on me!

I have two tables of Customer Data in the same database, one from December one from April. The April table includes all the records from the December table and additional new records. The field names in both tables are identical and there is a ShipToID that is unique to each record in both tables.

What I'd like to do is make a new table with only the records that are in the April table that are not in the December table. Sort of April - December.

Any help is greatly appreciated!

- Lee

 

[lespaul]

create your new table then run this query

INSERT INTO NEWTABLE (SELECT * FROM TblAPRIL where ShipToID not in (select SHipToID FROM tblDecember))

 

[owens2024]

Thanks for your help but when I try to run this query I get an error message "Syntax error in INSERT INTO statement"

This is my query (using the one you gave me)
INSERT INTO [New Customers] (SELECT * FROM [4-24 customer list] where ShipToID not in (select ShipToID FROM [12-9 customer list]));

I am using Access 97.

 

[lespaul]

Are they IDENTICAL tables? Exact same NUMBER of fields?

leslie

 

[owens2024]

Yes they are identical, same number of fields, same field names, same field properties...

- Lee

 

[lespaul]

If you just run this sub-query, do you get the records you would expect to see?

SELECT * FROM [4-24 customer list] where ShipToID not in (select ShipToID FROM [12-9 customer list])

Leslie

 

[owens2024]

I did so and got the records I needed... So I just changed it to a maketable query... and now I have what I wanted!

Thanks for your help!

- Lee

 

[lespaul]

YEAH!!

No problem!

Leslie