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?
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?