Compare and combine two tables with query.

[xopherira]

I have two tables that I need to query and combine. First table is the template and has part number, group number and serial number, with serial number being blank. Second table being imported has part number, group number and serial number, which serial number is provided. I need to compare part number and group Id and have the serial number value added to template. I am new to access and not sure how to query and build a table out of two tables. Also, anyone know where a good tutorial on debugging this stuff is located?

[ranman256]

Q1 run append query to the new table.
Q2 run an update query to update new tables SN field.

(or just run the update the SN field in table 1 from table 2)

[orange]

Debugging info

[xopherira]

Tried to run the update from table 1 from table 2 but get a prompt to enter parameter value. How do I remedy this, what am I missing? Also, if I add table 2 to select it returns to many values. Do table 1 and table 2 need to have same number of columns to upate properly?

[orange]

Show readers your query SQL. And table designs.

[xopherira]

I can't post anything direct from question due to the nature of my job and data that is involved. I have provided pseudo example.

[orange]

Take you query sql, and change the nature of the data to something inert ---
Houses and Rooms, States and Cities, Students and Courses-- whatever you're comfortable with.

It isn't the specific data so much as the concepts involved.

As for debugging, I gave you a reference earlier --did you review it?

[xopherira]

Yes saw the debugging, one question. Does this also work for access or do I have to convert code. I will post query tomorrow, on work PC.