By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,310 Members | 1,885 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,310 IT Pros & Developers. It's quick & easy.

Summing a specific groups

P: n/a
Hi

I want to get the sum of records based on a specific record filter (field
value), in addition to the report total which is the sum of all records. Is
there a way to do that in a report?

Thanks

Regards

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Use the Sum() function as a textbox ControlSource on the report.

Mike Storr
www.veraccess.com
"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:40***********************@news.dial.pipex.com ...
Hi

I want to get the sum of records based on a specific record filter (field
value), in addition to the report total which is the sum of all records. Is there a way to do that in a report?

Thanks

Regards

Nov 12 '05 #2

P: n/a
Does sum support some sort of condition I can use to get only records that
meet a certain field value?

Thanks

Regards
"Mike Storr" <st******@sympatico.ca> wrote in message
news:T0******************@news20.bellglobal.com...
Use the Sum() function as a textbox ControlSource on the report.

Mike Storr
www.veraccess.com
"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:40***********************@news.dial.pipex.com ...
Hi

I want to get the sum of records based on a specific record filter (field value), in addition to the report total which is the sum of all records.

Is
there a way to do that in a report?

Thanks

Regards


Nov 12 '05 #3

P: n/a
If you use it in a Group Footer, it will automatically limit the Sum to the
values that apply to that Group. You will, of course, have to use the
Report's Sorting and Grouping to set up the Groups.

An alternative would be to use the DSum domain aggregate function if it
isn't feasible to set up Groups, or embed Subreports based on a Totals
Query.

Larry Linson
Microsoft Access MVP

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:40***********************@news.dial.pipex.com ...
Does sum support some sort of condition I can use to get only records that
meet a certain field value?

Thanks

Regards
"Mike Storr" <st******@sympatico.ca> wrote in message
news:T0******************@news20.bellglobal.com...
Use the Sum() function as a textbox ControlSource on the report.

Mike Storr
www.veraccess.com
"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:40***********************@news.dial.pipex.com ...
Hi

I want to get the sum of records based on a specific record filter (field value), in addition to the report total which is the sum of all
records. Is
there a way to do that in a report?

Thanks

Regards



Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.