linking databases

[meleigh]

I have two databases, one that shows a list of all our customers for the past year excluding August and the other that shows a list of all our customers for August. What I need to do is run a macro that compares the two lists and gives me the names of those that appear on the August list but not the main list (ie new customers) but I can't work out what code to put in! Help, I have a report due by next week!

 

[SQL_Hell]

I would import one table into the database, so you have both tables in one database,

then write a query that looks for non matching customers,
do you have some kind of Id number that will realate the data?

 

[sfreeman@co.mer]

Yes, or just link to remote table

That is fine, but you could also just link to the other remote table and not worry about maintaining two sets of data.

Just a suggestion, the above answer is fine.