By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,946 Members | 1,610 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,946 IT Pros & Developers. It's quick & easy.

update to second table?

P: n/a

I don't quite have my Access/SQL terminology down so I'm having a hard
time searching on google for what seems like a simply query.

I have two tables.
Table1 about 200 records. FirstNAme, LastNAme, ChargeNum
Table2 about 400 records. Firstname, Lastname, ChargeNum, other fields...

I need to get the ChargeNum from table one into Table2. I have a query
that matches the names, but I cant seem to figure out which query to merge
them. Append I cant use because I need to retain the ID for each user.
Will an update query work?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
DaveDiego <Th************************************@usenet1.wi ntermute.cx> wrote:
I don't quite have my Access/SQL terminology down so I'm having a hard
time searching on google for what seems like a simply query.

<<>>

Whoops, figured it out :D

I needed the little [] bracket things around the field I wanted
transfered over.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.