Update Query?

[marie515]

Hi there.

Hi there,

I have two tables that I need to merge data from one table into another (based on Agency names matching).

[Table #1] - The MAIN Table from my database with multiple fields including "Agency Name" and "membership" (which membership field is currently blank)

[Table #2] - Table that has "Agency Name" and "Membership" with the numbers included for membership

How do I populate the membership numbers from #2 into #1?

Would it be a update query?

thanks for your help.

 

[BNPMike]

Join the two together and view membership fields from both tables. When you're happy with what you are seeing, click on Update Query and set Table #1.membership = Table #2.Membership. Then press the button.

 

[pbrown2]

I have a similar situation that perhaps someone could help with.

In a table (tblemployees) there are the fields [FN] & [LN] (First and Last Name). Also, in the table a new field of [Name] has been created. Is there away to run a Update Query to have Name = [FN]&" "&[LN] ???

Thank you for any and all help,

PBrown

 

[BNPMike]

Name: [FN]&" "&[LN]

Stick that as a new field in a query, test it , then turn the query into an update/append and you're away.