Dear all,
I have a column (unit rate and amount) in my report.
that has a formula in it, according to unit ID, total working per month, unit measuremet,..the other words it's a complex formula..

Now, I'm trying to calculate total of those column per month.
But I don't know how to do that, since 'my-rate and amount' are text box which have formula...and they're not an existing field from table..
Is it possible to do calculation??..

Any help would be appreciated
Thanks
regards,
Mut

Hi and welcome to the forum

You have a couple of options...

You can put the "complex" formula in the total field for the MonthID group like this:
=SUM([unit rate] * [amount])

Or you can perform the [unit rate] * [amount] in a query so that it is available to sum in your report.

hth
Chris

But it would appear a pop up window ask parameter to select on unit rate..
I think because unit rate has IIF formula in it.

Sorry I'm newbie here.. It's much easier if I could attached .mdb file.
it 1.3Mb... only for .rar can get <1Mb.. but invalid for sending to this forum.. can I have your e-mail or something I could do to share this .mdb file..?