Access query to combine tables 1

[phjames]

Hi,

Thanks for reading my post. I'd like some Access advice please.

I have 2 tables.

Table 1 has fields inventory, item_no, common_item_no
Table 2 has fields Res_qty, item_no

item_no is the unique identifier between tables.

I would like inventory and res_qty adding together and put into a new 3rd table with these fields item_no, common_item_no.

I hope this makes sense and thanks for any replies or pointers.

James.

 

[SkipVought]

So did you try a query joining the two tables on item_no?

If it looks good, make it a MakeTable query. But why bother with this step?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[kjv1611]

phjames,

For future reference, questions about Access Queries should go here:
forum701

 

[randy700]

You don't need a 3rd table.
Just link the tables in a SELECT query.

SELECT table1.item_no, common_item_no, inventory + res_qty AS total_inventory 
FROM table1
INNER JOIN table2
ON table1.item_no = table2.item_no

Randy

 

[SkipVought]

echoing in here ;-)

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[phjames]

Hi,

Thanks for the replies. I linked the tables like randy700 suggested.

Thanks,
James.

 

[SkipVought]

I linked the tables like randy700 suggested

ONLY randy???

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[kjv1611]

 

[SkipVought]

ROFL: Me 2!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]