Report Grand Total not working

[BrazilTechie]

Hey guys:

I am creating a report of dealers sales. On the Dealer Table has a field with a total for each month.
I am grouping my report by dealer and all is fine on the Dealer header where I simply use the following code to get the total for each dealer for the months of January and February for example:

=(IIf(IsNull([JAN]),0,([JAN]+(IIf(IsNull([FEB]),0,[FEB]))

What I am trying to do now is to get the grand total for all dealer on the report footer.

I've tried a few things but it has not been working.

Any hints?

Thanks in advance.

BrazilTechie

 

[dhookom]

Consider using Nz() rather than the IIf(IsNull(...),...)
=Sum(Nz([JAN],0) + Nz([FEB],0))


Duane
MS Access MVP
Find out how to get great answers faq219-2884.