Merge two tables with similar data in access


G

Guest

I have inventory data from seven different Tech Trucks that are being dumped
back into the main warehouse as the Techs are being eliminated in that region.

Each inventory is currently in its own table, with fields for Part#, Qty &
Cost. I need to add the quantities of like Part#'s, so that all Part#'s will
be accounted for in a new Inventory table that will represent what will be
put back into the main warehouse.

How can I combine the Qty fields for all of these Tables together into a
single query, and keep the Part# and Cost fields attached to these Qty's?
 
Ad

Advertisements

G

Guest

A union query (UNION ALL Select ...) will bring all together then use it as
source for a totals query to sum the quanities.
 
Ad

Advertisements

G

Guest

Thanks Karl. That is exactly what I needed! I didn't know about the Totals
thing - I will probably find that very useful in the future.

-Matt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top