Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
if then is one of select
- Thread starter smeyer
- Start date
if (@storeNum) = 1 then (drawNo) in 11 to 13
else
if (@storeNum) = 2 then (drawNo) in 21 to 23
The above formula will only work if you want EVERY value between 11 and 13. or say you had non-consective {drawno} for a given condition, then slightly modify your formula as follows
if (@storeNum) = 1 then (drawNo) in [11,12,13,17,24,31] Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
else
if (@storeNum) = 2 then (drawNo) in 21 to 23
The above formula will only work if you want EVERY value between 11 and 13. or say you had non-consective {drawno} for a given condition, then slightly modify your formula as follows
if (@storeNum) = 1 then (drawNo) in [11,12,13,17,24,31] Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
- Status
Similar threads
- Locked
- Question