Hello, I have a question that I hope someone could help with.

· I have a database that shows Storm water data for each record.
· The data is inputted to a table through a form.
· The form shows fields such as Temperature, Chlorine Level, Flow, etc.
· I also have a report
· The report shows monthly data that computes the maximum, minimum, and average levels for each parameter above. For example we will use [Chlorine Level].
· Let’s say for example I have data points for [Chlorine Level] of 1,2 and3, 3 being the maximum, 2 being the Average and 1 being the Minimum
· Question 1: How can I show another expression in the report that shows how many times that [Chlorine Level] was tested for? For example in this scenario it was tested 3 times. What would the expression equation be for this textbox?
· Question 2: I also want to show the number of times that the set of 3 results exceeded 1. For example in this scenario it would be 2 excursions. Therefore I would want the text box to display “2”. I currently have an expression =IIf([AvgOfClorine Level]>1 Or [MaxOfChlorine Level]>1,"1","0"). But this does not do the job. I would need a more dynamic expression in place of the “1” section to capture the total number of times that the avg or max exceeds 1. Any ideas.
Thanks
Kevin

Add a textbox in the detail section of the report running your iff statement, once you have it showing 1 next to the records where the conditions are meet then you can name the textbox and hide the textbox, then either in the report header or group header/footer you can sum the textbox value.