Update Query to update data

  • Thread starter Thread starter Fernando
  • Start date Start date
F

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
 
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.
Click to expand...

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?
 
Back
Top