How can I combine two records and all its fields in Access? For
example if I have a part number that got replaced with a new part
number. I need to combine the sales of both records but only take the
value of the old record for text string fields. For example if I have
a database with 2000 parts and 5 of these parts are new I need to add
the history of the corresponding old parts to the new parts for
history purposes. All help greatly appreciated.

Thanks!
JCA

Hi, JCA

I can't tell exactly what you're trying to do, but it sounds to me as if you
want to concatenate - i.e., combine two text fields into a third.

This is done using the "&" symbol.

Open up a query and add the table with the values you want.

Say there's a field called OldPartName and there's a field called
NewPartName.

You then set up a select query with the field OldPartName&NewPartName to get
the result you want.

If you prefer, you can run a Make Table query to create a permanent new
table.

L.