Solved Totaling 3 rows controls into 1 control

[moi]

To all,

I need help in my report.. I wanted to total in 1 control the 3 rows of commission controls.. Opps i cannot attached a..

Any help would be appreciated.

 

[June7]

Should be able to attach db file or images. Follow instructions at bottom of my post.

Why do you have 3 rows? What have you tried?

 

[moi]

Should be able to attach db file or images. Follow instructions at bottom of my post.

Why do you have 3 rows? What have you tried?

attached image..

I wanted to put the total control beside name control, is this possible?

 

[June7]

Is the name control in a group header or footer section? Try a textbox with aggregate expression: =Sum(Amount).

 

[moi]

Is the name control in a group header or footer section? Try a textbox with aggregate expression: =Sum(Amount).

it is in the byrid header (grouping)... tried that function already sir..

Anyway i used this in the control i wanted to total..=(([Amount]/[TCP])*100)/100.

 

[moi]

Is the name control in a group header or footer section? Try a textbox with aggregate expression: =Sum(Amount).

I got if solved..thanks.. =Sum(([Amount]/[TCP])*100)/100.