Multi Field Update Query

[artemetis]

tblPrimary has the following fields

ID
mapID
map1
map2
map3
macID
mac1
mac2
mac3
madID
mad1
mad2
mad3

How do I go about having an Update query, set/insert the mapID,macID,madID fields = to the value of the ID field?

[ChipR]

1. Open query designer
2. Add tblPrimary
3. Right click the blank design area next to the table and select Query Type->Update Query
4. Double click each field you want to update
5. In the Update To: section of each field at the bottom, put [ID]
6. Execute

[artemetis]

@ChipR
Thanks!
I did this and got an error?
Will try again and post back error.........thanks again :o)

[artemetis]

Ok, getting a "Record too large." error.
There are 549 records and I tried to reduce the update to only update one field....error still persists. ???

[ChipR]

I haven't seen that one before. It may indicate that the ID value doesn't fit into the field you are trying to copy it into. Like trying to copy a long int into a short int. Do you get a specific error number?

[NeoPa]

I suggest you post here the field types of all the relevant fields ([ID]; [MapID]; [MacID]; [MadID].

I expect this will make the problem clearer

[artemetis]

Thanks folks! Apparently "something" happened with my linked spreadsheets. I ran the linked table manager and voilà!

I said it before and I'll say it again.........you're all terrific. :o)