Sum iif in detail section

thesven

Registered User.
Local time
Today, 08:59
Joined
Apr 14, 2009
Messages
23
So yes I am still new to Access and have run into a snag.

In my report detail section I have the following

=IIf([Billing]="Daily",[Number of On Duty Days]*10,0)

This does exactly what I need but now I need to SUM this, any help is appreciated.
 
I figured this out if anyone is interested

=Sum(IIf([Billing]="Daily",[Number of On Duty Days]*10))

Apparently you can't sum a text box from one section to another.
 

Users who are viewing this thread

Back
Top Bottom