Subtotals For 1 column

[jonboy6257]

Hello memebers. I have an access DB i am trying to get subtotals for. The table being used is called tbl100 and it houses our inventory. There are 4 columns: Bin, Qty,Item, Zone All fields are text except Qty. There are 8 zones Zone 101, Zone 102.....up to Zone 108. I am trying to sum the totals for each zone in one query. I had originally done 8 different queries with a different WHERE clause in each. I have now tried to union the table upon itself but that places all the totals in the same column. Is there an easier way to sum up the Total Qty for each zone in one Query? Ideally the column names should be returned as Zone 1, Zone 2... Zone 8 with the totals underneath.

[jonboy6257]

For the union query I am using the following code:

Please Login or Register  to view this content.

[alansidman]

Why not just make one aggregate query that groups on the zone. Look at this link on aggregate queries. Post back if you need additional help

http://www.techonthenet.com/access/f...umeric/sum.php

[cycloneboy]

SELECT tbl100.Zone, Sum(tbl100.Qty) AS SumOfQty
FROM tbl100
GROUP BY tbl100.Zone;