T
TommyP
Hello,
Â
I have been searching the existing posts for an answer to my issue. Many
have similar suggestions, but none of them quite fit my problem, so I
apologize if you feel this is redundant. Here we go:
Â
The ultimate goal is to append new records (and new records only) to an
existing table. When the query runs to append records which do not already
exist in the table, I need the query to compare the entire record in the
table to the entire record in the query (as opposed to one field where an
unmatched query would be useful). My reason for this is that it is the
entire combination of fields in each record which make the records unique.
Â
For example, the records in the existing Table are:
A-B-C-D
B-C-D-E
(With each letter being a field).
Â
The Query will produce record results of:
A-B-C-D
B-C-D-E
C-D-E-F
Â
I only want C-D-E-F to append to the table. I want the query to "see" that
the combination of C-D-E-F does not exist in the table, and to append it.
Â
I am a fairly new user to Access, so simplified explanations would be
greatly appreciated. Thank you so much.
Â
I have been searching the existing posts for an answer to my issue. Many
have similar suggestions, but none of them quite fit my problem, so I
apologize if you feel this is redundant. Here we go:
Â
The ultimate goal is to append new records (and new records only) to an
existing table. When the query runs to append records which do not already
exist in the table, I need the query to compare the entire record in the
table to the entire record in the query (as opposed to one field where an
unmatched query would be useful). My reason for this is that it is the
entire combination of fields in each record which make the records unique.
Â
For example, the records in the existing Table are:
A-B-C-D
B-C-D-E
(With each letter being a field).
Â
The Query will produce record results of:
A-B-C-D
B-C-D-E
C-D-E-F
Â
I only want C-D-E-F to append to the table. I want the query to "see" that
the combination of C-D-E-F does not exist in the table, and to append it.
Â
I am a fairly new user to Access, so simplified explanations would be
greatly appreciated. Thank you so much.