I have a text field lets call it [field1] that contains this combination types of data that I will be using a query to grab:
30% ($25 min)
30% ($50 max)
30% ($25 min $150 max)
there will be no deviation it will be one of these 3 types.
I need to take the min and max data and place it into 2 different fileds.
I need to grab - when "min" the 25 (no dollar sign)
and when "max" grab the 50 or 150 (max can be 2 or 3 digits) no dollar sign.
I have the idea of finding when it exist using the like function so it would look like
Retail Cost Min: iif(like "*[Field1]*"="min", , "")
Retail Cost Max: iif(like "*[Field1]*"="max", , "")
but I don't know what to use to grab the exact data in the middle.
Any ideas anyone.