Here is an example of the issue: A real estate office has some showings that are awaiting confirmation.
I have a field that has a count of "1" in records that meet that criteria.
What I would like is to display the total of all the "1"'s even when all those records are not in the found set.
So if there are 5 showings awaiting confirmation, it would display the #5 on the screen even if all 5 are not in the current found set.
I created a summary field for "Total" but it only shows the total count of the displayed records.
There must be an easy way to do this. isn't there?
Thank you for any feedback!