Category sum

[Royal Presence]

I have a different problem now.

I can't calculate the category to sum. I would like to sum the category of products.

I have a product table, category field is in the orders form and the product list, then the quantity is in orders. I tried relating and calculating. Again, this was done in excel nicely with subtotals based on category. How can I do this in Access?

Because I think backwards, I'm thinking I have to export to Excel and back again? Ugh!

 

[SydneyGeek]

If you just want to view it, use a Totals query.
Build a query with Category, Quantity and Price (or Extended Price) then click the Sigma button on the toolbar. you'll get another line in the query. By default all the fields have Group By as the summary function. For extended totals by category, change the function under Extended Total to Sum.

Note: once you have a Totals query you will only be able to view data. No data entry. For printing, base a report on this query.

Denis

 

[Royal Presence]

Thanks Sydney- it worked.