Query Question two different totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that contains items that are in two locations ( pick) or (Bulk)

I have been able to total them all together to show grand total
I can query each by location

What I would like to do is to show a line that has the item, bulk quantity,
and pick quanty

I have attempted to join them together with all join options but it
eliminates some pick quantities as there are pick quantities that do not
contain bulk quanties as well.

ITEM PICK
112909 97
112932 1
13954 97
14103 20

ITEM BULK
112909 96
13954 292
14330 100
16172 79


I would like to see
ITEM PICK BULK
112909 97 97
112932 1 0
13954 97 292
14103 20 0
14330 0 100
16172 0 79
Is there way that this is possible to complete
 
I was able to resolve it in a round about way

I took BULK table used insert into to a new table Took the PICK table and
used insert INTO the same table then a simple query to sum the fields 0 =
desired number returned what I was after.
 
Back
Top