Sum of Report Category

[Costefran]

Can anyone help

I have a report with a number of categorys and would like to sum the currency value of each line within each category

Is this possible

Many Thanks

 

[dhookom]

You can create totals of numeric and/or currency values in reports. The sums are generally placed in group or report headers or footers. If you can't figure this out, come back with more information about what you need.

Duane MS Access MVP

 

[Costefran]

This isn't exactly what I need but many thanks

I have set up category headers in my report and was wondering if I could sum a value in the particular category

 

[dhookom]

Where and what do you want to sum? Is "a value" a field or a calculated field or result of a fuction or what?

You mention "particular category". Does this mean you only want the sum in one of the category headers and not the others? Or, do you want the category sum in a report header or footer but only want the sum to reflect values from one category?

It would really help if you provided either more specifics or even better provided some sample data and desired display in the report.

Duane MS Access MVP

 

[Costefran]

Thanks again for the response

Here is some sample data of two categories (although there are more)

Book Orders Category
Order 1 Total Cost=£10
Order 2 Total Cost=£22
Sum of Book Orders Category Total Cost=£32

Toy Orders Category
Order 1 Total Cost=£12
Order 2 Total Cost=£25
Sum of Toy Orders Category Total Cost=£37

The Total Cost Value is sourced from an underlying query and as you can see I want to calculate sums of each order in each category. Each category may grow or expand. E.g. more or less orders depending on the results of the underlying query.

Hope this helps

 

[Costefran]

Dear dhookom

I think I've just cracked it!

Didn't realise I could create a category footer, so created a control that =sum([Total Cost]) and it works

Many thanks for your help and patience

Rgds
Costefran