?
Solved

Move Zero if value is null or spaces

Posted on 2006-11-16
5
Medium Priority
?
225 Views
Last Modified: 2006-11-18
Hi: Can any one please tell me how do i move zero if value is equals to space or null?

strAmountofPPVDispute

Thanks.
0
Comment
Question by:mustish1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 61

Assisted Solution

by:mbizup
mbizup earned 400 total points
ID: 17957238
What do you mean by "Move Zero"?
0
 
LVL 66

Accepted Solution

by:
Jim Horn earned 1200 total points
ID: 17957240
Define 'move zero'.

If Nz(YourValue, "") = "" OR Nz(YourValue, 0) = 0 then
  'do something here
end if
0
 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 400 total points
ID: 17957261
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
 
LVL 44

Expert Comment

by:GRayL
ID: 17957341
Looks like we'll never know!
0
 
LVL 44

Expert Comment

by:GRayL
ID: 17972504
Does anyone see any value in leaving this question here.  Unless mushish1 comes back and 'explains' I think it should be deleted.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question