Recent content by CORiverRat

When I try that not in statement in an append query to look at the field in the MASTER db it still adds a new record for each entry. the format I have is NOT IN(SELECT SerialNumber from MASTER). One other note, this is one of the fields I am pulling from the 2nd db to be added to the...

My exact problem is that there is NO master sheet that has every device I am looking for and all of them have different information in them. I would like to be able to pull the different info (some have network info, some have asset info, some have location info) into one record. I realize...

So you can do a conditional append query? If that is true then I think I figured out how to do this. How exactly would one go about setting up a conditional append query, to only grab those records that are not already there? Once that is done I can do a series of regular left sided join...

Question... Will this pick up records with serial numbers that are not in the first table I create. That is where I am running into the biggest difficulty. Because of the nature of the joins I can't seem to be able to snag all the records that are in some all of the tables without creating...

I have several tables I have brought in from excel spreadsheets. Each one has one common column (lets call it serial number), but then all the rest have a variety of information (one has location info, one has network info, one has asset tracking info, one has sw load info, etc). What I want to...

I have several tables I have brought in from excel spreadsheets. Each one has one common column (lets call it serial number), but then all the rest have a variety of information (one has location info, one has network info, one has asset tracking info, one has sw load info, etc). What I want...