Sum in Detail section

[kbreiss]

I've searched several pages regarding sums and I'm still having trouble.....In my detail section I want a sum of each row. I thought it would be a simple textbox w/ its recordsource as =sum([count1]+[count2]+[count3]), but I have worked all afternoon on it w/ out getting it right. This report already comes from three different queries. Is there anyway just to some control sources?

Here's what my report looks like....

number count1 count2 count3 sum
1 5 7 10 ?
2 0 9 8 ?, etc.

I'm trying to get a sum in the detail section.

Any help would be appreciated.

Thanks,
Kacy
________
Dominatorqueen

 

[kbreiss]

Pat,
When I tried the code you gave me in the total field I'm getting the columns concatenated together.

Say I have

7 5 3 = (its giving me) 753...........instead of 15.

Any ideas why it's doing this? These are numeric fields.

Thanks,
Kacy
________
DEPAKOTE ATTORNEYS

 

[kbreiss]

Pat,
I thought the same thing that the fields must be text. I noticed it would allow me to take the field and multiply it though. I tried doing something like this. =count1 *1 + count2*1 + count3 *1 and it summed the fields correctly. Strange, but it worked. Just thought I would pass it on.


Kacy
________
ANGER MANAGEMENT FORUMS