Hey
I have a report of a query that looks kind of like this:
---------------------------------------------------
Breaker || Rating || With auto?
1 || 2000 || N
2 || 1000 || Y
3 || 2000 || N
---------------------------------------------------
Now I need to find the minimum value of "rating" which I know can be done using the report summary- it spits out "1000".
However, I need the summary to display the minimum value of the records in which "with auto?" is NOT "Y". i.e. it should disregard the record with "N" in it and display the minimum value to be, in this case, 2000.
How can I modify my report summary to do this? When I open the expression that computes the min on the report in expression builder it shows me
"=Min([Breaker])"
I tried to add in:
"=Min([Breaker]) where [with auto?]<>"Y" "
but that didn't work.
Is there code i can put in the code builder for this "event"?
I would really appreciate the experts' help! Reading all your advice on other threads has helped me tremendously but this is the first time I'm asking a question.
I have a report of a query that looks kind of like this:
---------------------------------------------------
Breaker || Rating || With auto?
1 || 2000 || N
2 || 1000 || Y
3 || 2000 || N
---------------------------------------------------
Now I need to find the minimum value of "rating" which I know can be done using the report summary- it spits out "1000".
However, I need the summary to display the minimum value of the records in which "with auto?" is NOT "Y". i.e. it should disregard the record with "N" in it and display the minimum value to be, in this case, 2000.
How can I modify my report summary to do this? When I open the expression that computes the min on the report in expression builder it shows me
"=Min([Breaker])"
I tried to add in:
"=Min([Breaker]) where [with auto?]<>"Y" "
but that didn't work.
Is there code i can put in the code builder for this "event"?
I would really appreciate the experts' help! Reading all your advice on other threads has helped me tremendously but this is the first time I'm asking a question.