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.
