Should not be to hard of a question

[Cpar]

I am having trouble with vba code for between. Such as if this box has a value within .11 and .25 then return "different control source" with "A". Like I said should be a simple enough question. I do not know why I can not get it. Thanks in advance

 

[CJ_London]

between do not work in vba - use >= and <= e,g,

myvalue>=x and myvalue<=y

 

[yupstrips01]

thanks for sharing this post, its helping me

 

[isladogs]

between do not work in vba - use >= and <= e,g,

myvalue>=x and myvalue<=y

Sorry but this isn't true
The following 2 SQL statements do EXACTLY the same thing

DoCmd.RunSQL "UPDATE SchConstants SET SchConstants.[Value] = Null" & _
        " WHERE (((SchConstants.ConstantID) Between 76 And 81));"

DoCmd.RunSQL "UPDATE SchConstants SET SchConstants.[Value] = Null" & _
        " WHERE (((SchConstants.ConstantID)>=76 And (SchConstants.ConstantID)<=81));"

I find the first version easier to use and less typing!

 

[CJ_London]

this is an old question, but it was not to do with writing a sql statement in VBA (in which case I agree with you) but using VBA e.g.

if X between 1 and 3 then...

 

[isladogs]

Hi Chris

I responded when the thread was resurrected by rebeccajr
EDIT: rebeccajr's posts have since been deleted...!

Anyway - that wasn't how I read the thread.
You are of course absolutely correct for IF statements

This works

If X>=1 And X<=5 Then MsgBox "The value of X = " & X

but this doesn't

If X Between 1 And 5 Then MsgBox "The value of X = " & X

Cheers