conditional sum in a text box

[vicsaccess]

I have a form with work to be done and the number of hours of each job. also on this split form is a scheduled date the the scheduler enters a date during the weekly scheduling meeting. I have a unbound text box giving me a sum of total hours of all the work, can I put another unbound box for the total hours of all the scheduled work? I've been searching all morning and trying different things but none have worked. I would think something like =sum([hours]) where [scheduleddate] is not null but im setting syntax errors.

[pbaldy]

Try

=Sum(IIf(IsNull(scheduleddate), 0, hours))

[vicsaccess]

thanks pbaldy, glad to see you back

[pbaldy]

Happy to help!