Hey guys,
I have a report that a user can filter with multiple sets of criteria the issue is that functions like =Count() will just look at the record set and ignore any filter I have.
At the bottom of my report I have:
="Total Scheduled Audits: " & Sum("[ScheduleDateCount]")
="Total Completed Audits: " & Sum("[StartDateCount]")
=" % Complete: " & (Sum([StartDateCount])/Sum([ScheduleDateCount]))*100
I need those fields to count only the records shown in the report not in the query. I did Google quite a bit but I can’t seem to find anything that delt with this particular question.
I have a report that a user can filter with multiple sets of criteria the issue is that functions like =Count() will just look at the record set and ignore any filter I have.
At the bottom of my report I have:
="Total Scheduled Audits: " & Sum("[ScheduleDateCount]")
="Total Completed Audits: " & Sum("[StartDateCount]")
=" % Complete: " & (Sum([StartDateCount])/Sum([ScheduleDateCount]))*100
I need those fields to count only the records shown in the report not in the query. I did Google quite a bit but I can’t seem to find anything that delt with this particular question.
