Odd String Behavior with '>'

  • Thread starter Thread starter DocBrown
  • Start date Start date
D

DocBrown

Can someone explain this to me? I sure hope this isn't something obvious....

I have a VBA statement:

strWhere = ""
strWhere = strWhere & "((BAND([Availability],1)) > 0 )"

debug.print strWhere

What's displayed is:
"((BAND([Availability],1))

No matter what I do I can't get that '> 0 )' to be part of the string!
How can this not work?
I tried '>>' in the string but just the first one is included. I tried doing
a second concatenation of the last part, same result!

John S.
 
Never mind *grin*. Yup it was a duh momemt... Other code was truncating the
string as it was suppose to...

John S.
 
Back
Top