Sasoriza28
Registered User.
- Local time
- Today, 05:31
- Joined
- Aug 13, 2012
- Messages
- 13
I have this statement in the control source of a text box
=IIf([room] Between 100 And 220,"9AM","10AM")
Which is basically what I want to do but I didn't think about the fact that some rooms are 101a and 101b. How can I rewrite this to work with these rooms? Is there a way to write it so 9AM shows up for rooms containing "100-220" and ignore the A and B?
=IIf([room] Between 100 And 220,"9AM","10AM")
Which is basically what I want to do but I didn't think about the fact that some rooms are 101a and 101b. How can I rewrite this to work with these rooms? Is there a way to write it so 9AM shows up for rooms containing "100-220" and ignore the A and B?