Odd search problem?

[jhomer]

Im trying to preform a search on a calculation field whose definition is as follows:

Indicator = GetAsNumber ( Feedback_Survey::UnusableRecordCount )

the result of this calculation yields a 1 or a 0. I want to perform a find to separate values of 1 and 0.

My find criteria is simply >0 however this yields no results. Ive tried every other way to perform finds on this field however i continue to get the no matching records dialog box.

any ideas?

[BobWeaver]

Have you checked to see that you do actually get values of 1 when in browse mode? You might want to change the Indicator field from calculation type to auto-enter calculation type so that it can be indexed. Unindexed searches can be problematic.

[Ron F]

make sure you have your calc defined as a number.

[jhomer]

Yes ive tried all your suggestions (and several other methods) and still had no luck. I eventually changed the calculation to an If statement and for some reason that did the trick ?!?!?!?!

still have no idea why i was running into the problem but hey it works now so im happy.

thanks to all for the input