June7
AWF VIP
- Local time
- Yesterday, 23:36
- Joined
- Mar 9, 2014
- Messages
- 5,470
Also surprised at the Switch() performance.
FFS and RangeValue are declared variables? Looking at prior posts, they appear to be number datatype. Don't see anything wrong with the construct. The parens are not needed but shouldn't hurt. Following should work as well
strWhere = "FFS = " & FFS & " AND " & RangeValue & " BETWEEN RangeLow AND RangeHigh"
Is your table actually named "sometable"?
FFS and RangeValue are declared variables? Looking at prior posts, they appear to be number datatype. Don't see anything wrong with the construct. The parens are not needed but shouldn't hurt. Following should work as well
strWhere = "FFS = " & FFS & " AND " & RangeValue & " BETWEEN RangeLow AND RangeHigh"
Is your table actually named "sometable"?