Count of Blanks

[aguest]

I was just wondering if there was a way of getting filemaker to count blanks. I've got a GRade field, which for some reason hasn't been popluated in all instances (Although I've not forced it to before saving record). I want to be able to count the number of blank records but filemaker won't seem to do this for me.

As you can see from screen shot I've writen a simple SQL statement which is returning an array, the first row of which I would expect to see 3 instead of 0 as there are 3 blank records in the time period been checked.

Any help greatly appreciated.

[Lee Smith]

Have you tried doing a find for blank fields? 

Enter find mode, enter the equal sign = into the field

Perform Find.

This should give you all records that are blank in that field.

 

[eos]

I was just wondering if there was a way of getting filemaker to count blanks.

​Count records, rather than potentially empty fields; i.e. COUNT ( * ) instead of COUNT ( Grade )