Hi. I've got some reports to gen

[sliptdisk]

Hi.

I've got some reports to generate that are gathering data from a table that ranks the organizations members on a scale from 1 to 8. Each member is part of a unit that I'm summing the total number of members, at each rank, resembling the following:

Unit 1 2 3 4 5 Other Total

601 4 3 0 1 0 7 15
602 3 1 6 2 2 4 18


and, so on. What I need to do is to collate the values from fields 6,7, & 8 into one "Other" field. Furthermore, I need to sum the values for each field (1-8) at the bottom of the report. Can anyone tell me how to do that? Currently, my query is just sorting all 8 fields, but, I need to condense them. More important is the summing at the bottom of the page, though. Thanks.

Dan

 

[Rohdem]

To sum the fields, all you have to do is place a text box at the footer of the report. In the control source, type

=sum[field1]

To sum across each record, you could create a variable in the query that sums the fields i.e.

total: [field1] + [field2] + [field3]

Mike Rohde
rohdem@marshallengines.com

 

[sliptdisk]

Thanks. I tried putting the text box in the footer, but, I think it wasn't linking because of a problem I've been having on the relationship end of things. I'll give this a shot in the morning.

Dan

 

[sliptdisk]

I'm afraid all I'm getting at the bootm of the report is "#Error", when I insert the text box in the footer. Do you know what might cause that?

Dan

 

[TheInsider]

Hi,
It's a long shot but toggle your field's "Running Sum" property. If it is not set correctly you will get an error.

Rob Marriott
rob@career-connections.net

 

[Rohdem]

Check to make sure you are spelling the field name correctly. Also, if there are spaces in the field name, you need to enclose it in [brackets]. Other than that, I've never had any problems using the 'sum' function.

Mike Rohde
rohdem@marshallengines.com

 

[Guest_imported]

if the sum function is placed in the page footer it will messup. place it in the Report footer ot the section footer>

 

[sliptdisk]

The report footer or the section footer, huh? Ok. I'll give it a whack. Thanks.

Dan

 

[sliptdisk]

That got it alright, folks. Thanks very, very much. You helped me out, alot!

B-)

Dan