Update query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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


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