423,680 Members | 2,394 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,680 IT Pros & Developers. It's quick & easy.

Null Zero

P: 20
I am having issues putting null zero function on the above formula.
Expand|Select|Wrap|Line Numbers
  1. LaborHours: Sum(Left([ActualLaborHours],InStr(1,[ActualLaborHours],":")-1)+(Right([ActualLaborHours],InStr(1,[ActualLaborHours],":")-1))/60)
  2.  
what i am trying to do when the query runs i want it to display 0 if is null or blank.
2 Weeks Ago #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.