D
Dave
I think I need an append query but can't figure out how to design it.
I copied table 3 as 3A (they both have a 4 field composite key: SUPLR,
DEPT, EMPL and PO) and started an append query & selected 3A as the
target. Let's say that for each record where Fred (EMPL) is found in
3, I want to add a record to 3A using Fred's record data, but I want
to substitute other names found elsewhere in 3 for Fred, based on
criteria I supply. This may be confusing to the reader, so I'll
explain what I have as well. There are almost 10,000 rows in 3, and
wherever Fred appears, I need to add a record that has all of his data
except the names have to be different. Those names appear elsewhere in
3 as well, but they don't have the same SUPLR, DEPT and PO data.
Perhaps I need to do this in stages; as an append, then an update?
I copied table 3 as 3A (they both have a 4 field composite key: SUPLR,
DEPT, EMPL and PO) and started an append query & selected 3A as the
target. Let's say that for each record where Fred (EMPL) is found in
3, I want to add a record to 3A using Fred's record data, but I want
to substitute other names found elsewhere in 3 for Fred, based on
criteria I supply. This may be confusing to the reader, so I'll
explain what I have as well. There are almost 10,000 rows in 3, and
wherever Fred appears, I need to add a record that has all of his data
except the names have to be different. Those names appear elsewhere in
3 as well, but they don't have the same SUPLR, DEPT and PO data.
Perhaps I need to do this in stages; as an append, then an update?