Select to view content in your preferred language

vbscript for NOT displaying zero's in attribute field for labels

2636
11
Jump to solution
10-23-2012 07:53 AM
nimitz
by
Frequent Contributor
Hey all,
I'm trying to label some wells with their ID and analyte value,  but if the well has a zero I don't need it labeled. Could anyone take a look at what I've got so far? I keep getting an error, but I can't seem to figure it out.
The function is calling our 'Silica', and I"m wondering if this field needs to be all uppercase?
Function AnValue ( [LOCID] , [Silica] )   if ( [Silica] > 0 then   AnValue = [Silica]   end if  End Function

Any help is appreciated,

Randy
Tags (2)
0 Kudos
11 Replies
nimitz
by
Frequent Contributor
absolutely perfect!

Bravo, and many thanks Ken!
0 Kudos
KenBuja
MVP Esteemed Contributor
Glad to help. Don't forget to click on the check mark in the post that answered your question.
0 Kudos