--- In [email protected], "bigjohn820" <[EMAIL PROTECTED]>
wrote:
>
> I have a timesheet form that I am converting to access (Currently
> manual).
>
> I can link 7 text boxes (days of week) for Vacation, Sick, Family
> Sick... ect... per person to my db. Each week starts a new
instance
> in the db.
>
> At the end of each row, I want to show the total for the week and
> anything zero I want blank (The kicker) on the fly. If someone is
> scheduled for vacation and I put 8 in a box, then I want the total
> value to update immediately. If I find out they are actually here
> and put zero in the 8's place, I want it to go blank. I can do
this
> with VBA but for all the different rows and not being able to use
> arrays, it's going to take a lot of code over and over - even
though
> it's all doing the same thing.
>
> It would look stupid to print out a timesheet with a hundred zero's
> in it.
>
> I was thinking of doind a combo of VBA and access default stuff but
I
> can't even show the total at the end of a row regardless of making
> zero's blank.
>
> Any help?
>
> James
>
I figured it out using IIF and NZ..
IIF(NZ([SickHoursMonday],0)=0,"",NZ([SickHoursMonday],0))
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
