Adding integers to NULL values ? 1

[Webkins]

I am using Access 2003. I have this following VBA expression:

overtime = monday + tuesday + wednesday + thursday + friday + saturday + sunday

For example, if monday = 9 and any of the other days are null then overtime = null. How can I add this string and result with an answer of 9 ?

Thanks so much...

 

[dhookom]

Webkins,
I hope this doesn't resemble your table structure. Typically a normalized table structure requires summing across records and not fields.

Regardless:

overtime = Nz(monday,0) + Nz(tuesday,0) + Nz(wednesday,0) + Nz(thursday,0) + Nz(friday,0) + Nz(saturday,0) + Nz(sunday,0)

Duane
Hook'D on Access
MS Access MVP

 

[MazeWorX]

what are your qualifiers for OT? Can you provide the criteria for OT? anything over 8?, over 40? calculated daily? weekly?

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>