iif question with "where" clause? 1

[meldrape]

Hi there,

I have a timesheet report and I'm trying to breakout totals in the report footer. I already have a grand total, a regular time total and over time total, but now I need a "personal time" total. The field is "task" and the task is PTO. So I need it to do the following:

=iif ([task]="PTO",sum([hours]),"0.00&quot

THis isn't working. I have some test data for 2.5 hours for the task PTO and it's not finding it. I know my syntax isn't correct. I'd very much appreciate any ideas. Thank you very much in advance.

 

[CosmoKramer]

Try the DSum function. Try something like this as the control source:

=DSum("[hours]","YourQuery","[task] = 'PTO'")

 

[meldrape]

thanks, Cosmo. I will try that. I found another one of your threads just a few minutes ago, where you created an invisible text box in one footer then called it again in the report footer. I'll try both methods. Thanks again.

 

[meldrape]

Your suggestion worked great. Thanks for your help.