Solved

Move Zero if value is null or spaces

Posted on 2006-11-16
5
221 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
5 Comments
 
LVL 61

Assisted Solution

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

Accepted Solution

by:
Jim Horn earned 300 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 100 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

808 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