And where (in what table) did you define the calculation?
Define it as
IsEmpty ( dateCollected )
clear the do not evaluate if all referenced fields are empty check box.
Define this in the same table as dateCollected.
Then use a count of Summary field in the same table or the count function from a related table to count the records.
Thanks for input PhilModJunk.
There is one table - Gifts.
We have a calculation field with : "Uncollected Gifts : " & IsEmpty(DateCollected)
Which returns : "Uncollected Gifts : 1"
I had expected this to return 9, if only 1 of the 10 recirds has a date entered in it.
"Uncollected Gifts : " & NOT IsEmpty(DateCollected) on the otherhand Returns : 0
Am I missing a logical step here?
why would it do that as it only references a single record in your table?
As I have already posted, add a summary field set up as the total of Uncollected Gifts and it will return 9 if the 10 records you describe make up your current found set. If you need the total for all records in your table, you'll need to set up a relationship for this.