Thanks Richard. Field is text.
It is also defined pretty wide. I am sure it is more than that because in this one column out of 288 Not Empty is not true on every single record (5976 records) yielding a "?", where in fact there are only 3 records that a "Find" sees, each with only "1" in them. I may just ignore it: this is not a critical field! Ron Carr From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On Behalf Of Richard S. Russell Sent: Thursday, December 04, 2008 6:02 AM To: [email protected] Subject: Re: Not Empty... On 2008 Dec 3, at 18:43, Ron wrote: I have a field in the source data where Not Empty allows a pass for 5900 records, but a Find * on the source data returns only 3 records out of 5900, with a value of 1 in that field. The others show a ? in my output data. How do I find out what is in that field so I can kick it out? Ron Carr I usually get a "?" when I've allowed insufficient horizontal space for a field containing a number. Try ... (1) expanding the field horizontally on your layout. (2) applying to it a "Number" format that limits the number of decimal places displayed. (3) checking to see whether the field is defined as being of type Number. You might want to temporarily redefine the field as being of type Text, then do your Find, throw away the stuff you don't want, then redefine it back to Number.
