Update query

[Guest]

i want to add a field from one table to the already existing value in another
table. I am trying it in a update query but can't get it to work... here's
what i want to say in the update query "update to" area: [mtd]=

![newvalue] +

![mtd]...i know you can't do that there but that's
my intent...i want to append a value from one table to a already existing
value in another field in another table...when i do the above (in legal
format of course), it doubles the value but won't append it...

got any ideas?

thanks so much in advance......

 

[John Vinson]

i want to add a field from one table to the already existing value in another
table. I am trying it in a update query but can't get it to work... here's
what i want to say in the update query "update to" area: [mtd]=

![newvalue] +

![mtd]...i know you can't do that there but that's
my intent...i want to append a value from one table to a already existing
value in another field in another table...when i do the above (in legal
format of course), it doubles the value but won't append it...

got any ideas?

thanks so much in advance......

Could you explain "doubles the value but won't append it"???

Please open your Query in SQL view and post the SQL text here; also
give an example of the data you're starting with, the result you're
getting, and the result you want.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps