Calculated fields in a detail section... Is it possible?

[BrazilTechie]

Hi all:

I wonder if I could include a calculated field in a detail area. Such as =Sum([COMMISSION]+[OTHER]) included in a unbound field.
I am trying and I am not being successful.
Could it be because I am grouping records by salesperson?

Any help will be appreciated.

 

[hneal98]

are you including the fields you are basing the calculation on in the detail section?

 

[BrazilTechie]

Yes I am. The two fields I mentioned previously.

 

[SuicidED]

Hi as long as the two fields are number/currency your control source should be =[COMMISSION]+[OTHER]

 

[BrazilTechie]

Thanks everyone for your response.

I figured out why it was not working. I was not checking for a NULL in the field.

=(IIf(IsNull([COMMISSION]),0,([COMMISSION]+(IIf(IsNull([OTHER]),0,[OTHER])))))))

The above code took care of my problem.

Thanks again guys.

BrazilTechie

 

[hneal98]

Ah yes, the elusive null. I always get into trouble with that. Good work.