Hi,
You can use DCOUNT, DSUM, and so on, with an appropriate third argument (the
criteria). Since your end user are probably not expected to know how to
supply that third argument, your interface and your VBA code would have to
guide them, 'asking' the right question, or presenting the 'choices' (like
wizard do, if that is complex), and then, your code would push the result,
of the DCount or of the DSum, into the right unbound control, so the final
result is then seen by your end user.
Note that when you filter a form, the number of records satisfying the
filter is displayed, near the navigation buttons. That may answer very basic
"count" question, using only the already available interface.
Hoping it may help,
Vanderghast, Access MVP