Perform Find with decimal numbers
In a field, I've numbers with decimals (100.1) and just numbers itself all mixed up. is there a way I can search only numbers without decimals?
Perform a find using this as your search criteria in an "omit" request:
I can't think of a way directly, but if you create a calc field set to
Case( Round(Yourfield; 0) = Yourfield ; "" ; "decimal") result as text
Then did a find on the calc field for "decimal" you would get it.
Thanks both of you for taking your time to answer my question.
@Phil, I have my field as unique so it gives me the validation error. that is not the case. no criteria is matched. so don't find any records even though I have my data that I know for sure have some records with decimals. do you have any thought on that?
@Ninja thank you. such a brilliant workaround. :)
A unique values validation should not produce such an error message. Perhaps you have also specified that the field is numeric only? That's a known bug.
Bingo. yes it's numeric because I don't want my users to input anything other than numbers. Thanks for the help.
Retrieving data ...