I keep thinking this should be simple, but I've not found a good way to do it, despite lots of searching and experimentation.
I have a table with a couple hundred records for a conference registration. There are two things I'm trying to count across the entire database (one table only).
In a layout (typically used for printing), I'd like at the top of the page to appear a count of dropdown field for registration type (i.e., Standard, Speaker, Staff, Comp, etc.). So in the layout it would look something like:
I'd also like another, similar field in the same layout that shows a count of paid registrations (i.e., Standard and Speaker combined) based on another field called Registration Fee. If the field is greater than zero, count it.
Any help is appreciated. This is not simple like I thought....