Searching for ≥$$lower_bound in a manual find works because searching for ≥ 'any number' works in text fields. But searching for ranges in text fields does not work. If you field you are searching is number and numbers exist in your global variables then $$lower_bound...$$upper_bound would work if you use script as: $$lower_bound & "..." & $$upper_bound
Can you verify whether the field being searched is text or number and are you manually searching (which it appears you are) or trying to write a script?
oops sorry I accidentally clicked the "choose answer" button rather than "reply"
I am writing a script actually, my field that I am searching is a number.
When I set the variabe the window has some text saying "calculations must return text result" my global variable however is set via a numerical feild. So I am not entirely sure whether it is a number or text
It is okay for a global variable to hold numbers and sometimes you can get into issues with type casting but not in this instance. The field that matters is the data type of the field being searched. So if your global variables are:
$$lower_bound is set with 2
$$upper_bound is set with 21
... and you are searching a number field then use:
Enter Find Mode [ uncheck pause ]
Set Field [ thatNumberfield ; $$lower_bound & "..." & $$upper_bound ]
Set Error Capture [ On ]
If [ Get ( LastError ) // errors found ]
Show Custom Dialog [ "No records found"]
... do whatever you wish with your found set
brilliant, thanks, i think I was running into troubles mostely because I was putting my criteria into Perform Find [$$lower...$$upper] where you have limited use of scripts and operations. Thanks for your time and patience ^^