How to show current vacation time

[Brian62]

I have a form I am trying to show the vacation time used.

The table name is Timeoff, columns are: "Code" (shows Vacation and illness) and "Timeused" (Hrs used for vacation, example 8 hrs for the day)

I would like to add the "Timeused" (8 hrs) that has the "code" (Vacation) to show in the unbound text box.

=Sum(IIf([code])=[Vacation],[timeused],Null))

This is what I came up with, but I can't get it to work, gives me an #error. Any suggestions? Thx!



I would really like to add the total hours the employee gets bi-weekly and subtract from the timeused that was used for vacation to give what they have left.

[pkstormy]

I'd sum each field separately and then do the IIF instead of trying to sum and do an IIF in the same statement. Using Sum( and IIF( in the same statement is often problematic.