Update Query to update data

[Fernando]

Having trouble desigining an update query to update a
field in a table. Already imported the table from excel.
The relationship between the two table is an ID field.
Trying to update the records into a new field with a new
ID.

Thanks,
FI

 

[John Vinson]

Having trouble desigining an update query to update a
field in a table. Already imported the table from excel.
The relationship between the two table is an ID field.
Trying to update the records into a new field with a new
ID.

You'll have to post some more details. "Update the records into a new
field" is not meaningful to me! Are you trying to create new records
in the table (an Append query) or modify the values in fields in an
existing record (an Update query)? If the latter, how can you identify
which record you want to update if it does not yet have an ID?