=Count() with WHERE in Report
I am hoping someone will come up with this here. I know you folks know it.
I am creating totals on a report. Normally I might create a text box with the following expression:
This would count all the SSN fields on the related section.
What I need to do is something like this:
=Count([PositionID]) WHERE Me.PositionID = "Vacant"
So this would count only the positions that were vacant on the report.
Can I do this, or do I need a sub report or something?
Thanks for your time,
Look it up at: http://wrox.books24x7.com