Conversion HELP!!!

[mapat]

hello,

I have a text field on a table. Some values look as follows: 1 - 100
101 - 250
251 - 500 and so on

Is there a function that can return these two value ranges or these 2 tokens as an integer or number each ("1" and "100" for eaxample)??
Thank you

 

[realvilla]

You can set up a table with three fields: low, high and the value you want to post for each range. The table will look something like this:

LOW HIGH VALUE
1 500 40
501 1,000 70
1,001 2,500 90

and so on..
Next, set up a query based on these values. I call it "query by table example". Are you using Access?

 

[Moniker]

If the values are always separated by a dash (-), then find the dash in the string and convert to the left and right of it, like this:

LeftHalf = CLng(Left(StringName,InStr(StringName,"-")-1))
RightHalf = CLng(Right(StringName,InStr(StringName,"-")+1))