I would guess leave blank (Null). The Nulls are dealt with in the calc using Nz() function.
VIP
Windows 7 64bit 
Access 2010 32bit
I would guess leave blank (Null). The Nulls are dealt with in the calc using Nz() function.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
VIP
Windows 7 64bit Access 2010 64bit
Could you elaborate. Is it better to have nothing on the blank entries or is it better to have 0's?
Respectfully,
Lou_Reed
VIP
Windows 7 64bit Access 2010 32bit
=Nz([JobPrice1])+Nz([JobPrice2])+Nz([JobPrice3])+Nz([JobPrice4])+Nz([JobPrice5]) deals with Null in the fields. If you populate field with 0 then Nz() is not needed.
I don't normally default fields to 0. I handle the Nulls with Nz().
You decide what you prefer.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Form opens in wrong view
Can not refresh a form - what am I doing wrong?
Posting Permissions
Reply With Quote