I want a summ

[cstuckey]

Hello,
I am trying to calculate a net commission total in my report. I'm using a text box (different table) to pull in a total manual adustment total. I need to take the original commission total-Manual adjusted total= Net commission total. Can you tell me how to do this?

Thanks

 

[jeremie_ingram]

Are you attempting the calcualtionions on the forma itself? If so I will assume 2 things.
1) You display both the original commision data and the adjust data.
2) The totals for both of these items are actually textbaxes on the form containing calculations like SUM([Tbl1]![Commision Data]

If these are both correct, you aonly need to create another text box to run the final calcualtion between the two boxes.

 

[cstuckey]

Did just that.


Thanks