Or Operator Question

cmrabide

New member
Local time
Today, 20:45
Joined
Jul 20, 2000
Messages
8
I think this is an easy question that I'm just not getting, but here it is...

I'm using the code:
If (x=0 or x = "") or (y=0 or y="") then
blah
blah
blah
end if

The or operator isnt' working how i expect. I want to evaluate if x is 0 or "", and if y is 0 or "", and if either x or y are 0 or "" to execute the code. It works if one or the other is 0 or "" or if one is 0 and one is "", but if x and y both are "" it will not work. Any ideas? Am i way off track? Thanks,
Chad
 
Thank you very much, that worked perfectly, I just didn't know to check a null with the Isnull function.
 

Users who are viewing this thread

Back
Top Bottom