Leveling inventory with a query

[gregrlevy]

Hi,



I need help with a query. I have 2 tables with 2 columns. One column is a product stock number and the other column is a quantity for that product stock number. One table is for store 1 and the other table is for store 2. I would like a query to compare the 2 tables and level the quantity so each store has equal amounts of each product. And give an output of sending this amount to this store and this amount to that store so they are equal in quantities. Any help would be appreciated.

Thanks
Greg

[ssanfu]

I would be better to have one table with 3 fields: product stock number, quantity and the third column for which store. Then it is easier to make a query to do what you want.

Other wise, you could create a union query to get the totals by product stock number and comp[are them.