Merge two tables with similar data in access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt - 27 Feb 2007 18:57 GMT

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?

Reply to this Message

KARL DEWEY - 27 Feb 2007 19:15 GMT

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

Signature

KARL DEWEY
Build a little - Test a little

> 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.
[quoted text clipped - 6 lines]
> 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?

Reply to this Message

Matt - 27 Feb 2007 19:57 GMT

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

> A union query (UNION ALL Select ...) will bring all together then use it as
> source for a totals query to sum the quanities.
[quoted text clipped - 9 lines]
> > 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?

Reply to this Message