Data range Question - Very easy (1 Viewer)

[Benjamin Bolduc]

Hello,

I get stuck on the simplest things. I need to write an If-Then statment for a report Im working on that establishes a basic data range from .25 to .5

For Example:

If Efficiency < .5 and > .25 then
blahblah
End If

I've tried so many combinations, including Between but I just can't seem to get the format down right.

Can anyone help me out?

Thanks!
Ben

 

[antomack]

Try

If Efficiency Between 0.25 and 0.5 then
what to do
End if

 

[Benjamin Bolduc]

Thanks for the reply.

That didn't work though. I got a compile error saying it expected then or goto? Any other ideas?

Thanks!
Ben

 

[antomack]

Actually yeah now that I look back at it that syntax would be wrong.

You could do
If Efficiency < 0.5 and Efficiency >0.25 then

or use
Select Case Efficiency
Case 0.25 to 0.5
what to do?
case else
what to do?
end case

 

[Benjamin Bolduc]

I really should have known that. I think I need some more coffee this morning. Thanks for the help!