conditional formating

  • Thread starter Thread starter Steve Y
  • Start date Start date
S

Steve Y

Could someone please point me in the right direction.
I have a query that pulls data from several tables. It
then ties to a report that will show a list of 13 criteria.
On the report I did some conditional formatting so that if
a field failed its criteria it would show up red. I am
now trying to put a "counter" of some sort so that it can
give me a running total of passed criteria.
EX.

XYZ passed 7 of 13 criteria
ABC Passed 3 of 13 criteria

any recommendations on where I should start?

Thanks for your help!
 
I do something similar for conditional "counting".
in the report header format code:
intCount=0
intRptCount=0

in the report detail format code:
if condition then intCount=intCount+1
intRptCount=intRptCount+1

in the section that shows "XYZ passed 7 of 13 criteria",
put:
textbox controlname = "XYZ passed " & intCount & " of " &
intRptCount & " criteria"

that oughta do it...
 
Back
Top