Count?

[MnR]

hi,

how would i use a count function to return the number of occupied records?

The occupied records would have the WeightNeeded filled in and i need to count these, but exclude ones with a field called "Cancel?" set to Yes.

or i have just thought, or even better would it be possiable to make a script which when field "WeightNeeded" is occupied takes 1 off a global field so then i can get how many i have left?

[-Queue-]

Create a calculation of not IsEmpty(WeightNeeded) and Cancel <> "yes". This will return 1 when both tests are true. Then Sum(relationship::calcfield) will produce the number of related records which contain 1 in the calc, depending on the relationship.