HELP w/ SQL!

[Nick34]

Does anyone know why this statement will not work in the WHERE statement of my query???

Choose([1=Low Load; 2=Mid Load; 3=High Load],Between 50 And 190.4,Between 190.4 And 330.8,Between 330.8 And 518)

I can't figure it out.

Thanks.

 

[jbpelletier]

Maybe?!? the last "ending" = the next "begin"
Between 50 And 190.4[\b],
Between 190.4[\b] And 330.8,
Between 330.8 And 518


jb

 

[Nick34]

I just tried your suggestion and it was a no go. It works without the choose statement i.e., between 50 and 190.4.

 

[PHV]

Go in the SQL pane and amend your where clause like this:
WHERE
(([1=Low Load; 2=Mid Load; 3=High Load]=1 And [FieldName] Between 50 And 190.4)
OR
([1=Low Load; 2=Mid Load; 3=High Load]=2 And [FieldName] Between 190.4 And 330.8)
OR
([1=Low Load; 2=Mid Load; 3=High Load]=2 And [FieldName] Between 330.8 And 518))

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884