Move Zero if value is null or spaces

Hi: Can any one please tell me how do i move zero if value is equals to space or null?

strAmountofPPVDispute

Thanks.
mustish1Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
Define 'move zero'.

If Nz(YourValue, "") = "" OR Nz(YourValue, 0) = 0 then
  'do something here
end if
0
 
mbizupConnect With a Mentor Commented:
What do you mean by "Move Zero"?
0
 
rockiroadsConnect With a Mentor Commented:
what do u mean zero, give it a value of zero?

u could do this

    If IsNull(strAmountofPPVDispute) = True Then
        strAmountofPPVDispute = 0
    ElseIf Len(Trim$(strAmountofPPVDispute)) = 0 Then
        strAmountofPPVDispute = 0
    End If
0
 
GRayLCommented:
Looks like we'll never know!
0
 
GRayLCommented:
Does anyone see any value in leaving this question here.  Unless mushish1 comes back and 'explains' I think it should be deleted.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.