Comparisons...

P

PerplexedPeon

Hi all! I'm having a slight issue wrapping my head around this and was
hoping one of the resident experts could provide some input/samples.

The situation is that I am importing csv files sent in by local offices to
be merged into a master table which is used for reporting. Part of the csv
file information is a repID in the form of LName, FName (a single field).
What is needed is a way to compare the incoming RepID's to the existing
RepTable, prompt for additional information when a new one is found, then
insert new ones into the Rep Table
The catch is this. The repID field on the master table is a text field
which dervies the name from the RepTable's FName, LName fields ( bound to the
PK in RepTable [RepID]). The RepTable also has a RepID field which is an
autonumbering PK.
This wouldn't be an issue except that the additional information tied to
each RepID is required to produce certain reports.

My thinking is that this comparison should be made after the csv files are
dropped into a temp table but before the append into the master but am not
sure where to begin or, more precisely, how to do the comparisons.
 
K

KARL DEWEY

Build a query with all your fields you need to append plus a new field like --
My_RepID : [FName]&[LName]
Save the query.

Now you can compare this query to the master table in a select query the the
RepID field and My_RepID field are the same.
 
Top