Adding Columns to Table that contain Data

[zooyo]

So here is my question. I have two tables and I need to bring certain columns over to my master table from the 2nd table. I need the data within these columns to be carried over as well. I am fairly new with Access and I assume this is nothing more than an update query but I am not having a whole lot of luck there either. Thanks in advance for the help!

[JoeM]

Update queries are used to update fields in existing records.
If you wish to add records to a table, you would use an Append query to do so.

If you wish to add fields (columns) to existing records, you must first create the field in your destination table (if they do not already exist). Then you can use Action queries like Append and Update queries to write data to these fields.

There are some good tutorials out there on Action queries like Update and Append queries. If you do a Google search, you should be able to find a bunch (probably on YouTube).