I am trying to count the number of records in a table but I don't want to count any record that is blank or contains a zero.

Any thoughts- thanks from a FMP newbie!

What is the purpose here? You could just find for those records that are not 0 and null.

You can also use a summary field that sums up a simple calc: GetAsBoolean ( YourField ).

But again we can be more precise in a solution if we knew exactly what you need it for.

P.S. Is this a text filed or a num field?

Edited February 16, 200917 yr by Guest
added PS

I am creating a relational student achievement database. The field I am trying to count is a number field which ranges from 0 to 100. I need to count the number of cells which have number in them greater than 0 in order to get the total number of students who are absent. Then I can do a summary calc to get the total absences.....

The easiest thing for you to do is do a find for > 0 in the field. The number of records returned will tell you how many there are. You can script this if need be.