get values between A and B

[BRABUS]

Ok I know I am stupid and I must be doing something wrong.

I have a text box with a value in it, I need to find out what that value is and if say its between 0 to 5 I do one action and if between 5 and 10 I do another...all the way to 100.

I know how to do this in excel but cant work out where I am going wrong in Access after rwading the help.

Any pointers??


Cheers

 

[Brianwarnock]

Have you looked at Select Case

Brian

 

[BRABUS]

Cheers Brian, thast exactly what I needed. The help section is like using a dictionary when you cant spell

 

[Brianwarnock]

ROFL That is so true. Glad I was able to help

Brian