Need help with calc to find next 2 empty fields

[stann]

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

[-Queue-]

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.

[stann]

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 .

[Oldfogey]

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.

[stann]

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