Counting total fields that have a value?
How would I set up a calculated field that would display the total number of a specified field that has a value in it.
For example: A field called "Quantity". I want a calculated field to tell me how many separate records show a quantity for that table, regardless of what the actual number is. Suppose I have 10 records. 5 of them show a quantity. The total in the calculated field should be 5, however I can only figure out a way that gives me the total value of all the fields by adding the quantities together.