S
Stephen
I download Patron Information from a Ticketing database by
creating a series of flat files containing biographical
data, contribution information, constituency codes, etc.
This data is imported into Access into various and sundry
tables corresponding to the particular dataset.
Frequently the Ticketing database will have duplicate
patrons because we have dozens of data entry workers
working in various departments. There is a procedure in
our Ticketing database to Merge one patron record into
another. We choose a "From" patron and a "To" patron and
merge in that direction. If the "From" has middle-name
for example, and the "To" does not, the final record will
include the middle-name. If the converse is true and
the "From" has no middle-name but the "To" does, the
middle-name remains in the final merged record. In other
words, filled fields do not get overwritten with blanks.
I need to follow suit in Access and Merge patrons into one
record. Haven't been able to find anything about this out
there. Anyone got a clever solution to my rather prolix
question?
creating a series of flat files containing biographical
data, contribution information, constituency codes, etc.
This data is imported into Access into various and sundry
tables corresponding to the particular dataset.
Frequently the Ticketing database will have duplicate
patrons because we have dozens of data entry workers
working in various departments. There is a procedure in
our Ticketing database to Merge one patron record into
another. We choose a "From" patron and a "To" patron and
merge in that direction. If the "From" has middle-name
for example, and the "To" does not, the final record will
include the middle-name. If the converse is true and
the "From" has no middle-name but the "To" does, the
middle-name remains in the final merged record. In other
words, filled fields do not get overwritten with blanks.
I need to follow suit in Access and Merge patrons into one
record. Haven't been able to find anything about this out
there. Anyone got a clever solution to my rather prolix
question?