IIF statement with values not allowing the between statement to work

[mustangirl]

I have some heading values that represent time, for example 2210 2340 100 220. I put an unbound field in between those values in the detail section. I want the field to check and see if another value on the detail line is between 2210 and 2340, if so then place an X in the unbound field. However, when I go to between 2340 and 100 it searches 100-2340 not 2340-100. So then I tried > 2340 and < 100 then place an X in the field and that does not work. It seems to still recognize that as a between statement. any suggestions?

 

[Philly44]

If I understand you right I think you want Between 2210 And 2340.

 

[tempclerk]

What about >2340 OR <100? There is no number that is >2340 AND <100.