Hi

I have a query which brings in the following information:
Shop Month SKU Qty
Sample data might be:
AL 12 123 8
BU 12 234 1
AL 12 123 1
AL 12 234 1
AL 11 123 5

I wish to get subtotals by branch, date and SKU. The example above would
give:
AL 11 123 5
AL 12 123 9
AL 12 234 1
BU 12 234 1

I've tried every method I can think of and I'm guessing it may need multiple
queries to get the results I want. Usually I would use the query to create a
table, open it in Excel and do it there. This query brings back over 180,000
records, though, which is too big for Office 2K to handle in Excel.

Thanks.

Sorry! Wrong group!

Andy.

<Andy wrote in message ...
Hi

I have a query which brings in the following information:
Shop Month SKU Qty
Sample data might be:
AL 12 123 8
BU 12 234 1
AL 12 123 1
AL 12 234 1
AL 11 123 5

I wish to get subtotals by branch, date and SKU. The example above would
give:
AL 11 123 5
AL 12 123 9
AL 12 234 1
BU 12 234 1

I've tried every method I can think of and I'm guessing it may need
multiple queries to get the results I want. Usually I would use the query
to create a table, open it in Excel and do it there. This query brings
back over 180,000 records, though, which is too big for Office 2K to
handle in Excel.

Thanks.