Can't use a calculated field in a find request?

[Owen Mathews]

Hi,

I have a simple problem that I hope has a simple solution. I have a Person table that includes separate fields for first and last name. It also includes a "full name" field that is calculated; it just concatenates the other two fields with an intervening space. I'd like to be able to enter Find mode and search in this calculated field, but FM always reports "No records match this set of find requests."

I must be missing something important...

[Ender]

A search on a calc field like this should work.

You may need to rebuild the index for that field. To do this, change the storage option for that calc to unstored, close the Database Definition dialog, then go back in and change it back to indexed.

[Søren Dyhr]

You have defined the as such: Name & " " & Surname ...but have made the result of the calc' a number. Try to switch it to text??? it's likely to happen once an again, because number as type are default in the defs.

--sd

[Owen Mathews]

Thanks guys! I knew there must have been something I was overlooking. Changing the result type to text fixed me up.