Hello

I have a table with 2 fields "Number" and "Controlnumber"

I have 200 records in the table.

I need to find the first records that has both of those fields empty.

I tried to combine 2 IsEmpty statements in one calc but I couldn't get it to work.

Help is needed here if you can

Thanks

You could either use IsEmpty(Number) and IsEmpty(Controlnumber) as a calculated field, and perform a find for when this field equals 1; or you could enter an equals sign into both fields while in Find Mode.

Thanks for the help but the IsEmpty(number) and IsEmpty(controlnumber) doesn't work.

I am trying to find the first record out of the 200 that has both the number and controlnumber field blank. I can't seem to get it .

What do you mean by "...doesn't work"? I notice your fields appear to be Number. IsEmpty has a problem with numbers. The normal numerical equivalent of empty is 0 but FMP's IsEmpty misses the zeroes. Calculation fields are usually 0 rather than empty but ordinary number fields can be both. Are you in a position to ensure that the fields contain 0 if 'empty'?

Otherwise you need to use a calculation field which is 0 if Number is Empty or 0.

This is probably the best because you can use one field to be 1 if both fields are empty or 0.

Whichever way you choose, do the find and then sort on SerialID. (You do have serial numbers, don't you )

The other thing you could do is loop through the file but this is really loopey.

Thanks for the answer but it proved to me that the fastest way to get the first record with those two empty fields was to make another field which was a calculation combining the two fields into one and then simply finding the first one that is empty.

Thanks