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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Relationship Question 6
Access Updating inventory levels 0
How to Report Delta on Queried Data? 3
Question about appending new data to an existing table 4
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
Counting multiple memberships 1
One-to-one relationship 2
Lookup field and Relationships 2

Back
Top