Report Expression Building

[KMac]

I have a very simple report that pulls in data from the results of a query. There are five fields brought over. One is titled Position Rating and there are 4 values that may be choosen for that field in the original table. I have a ratings table with the following grades Excellent, Good, Fair and Poor. The location table links the Position Rating field to the Ratings table.



I tried to write a expression that would total each. Here is a varaitaion of what I have been trying =Count([Position Rating]=[Good]). I have tried quotation marks, ID values for the ratings moving things around and I can't get a count on each value.

I am relativly new to Access. I am able to get a count of all values so I am fairly sure I am close.

Thanks for any support you can give me.

[pbaldy]

Try

=Sum(IIf([Position Rating]="Good", 1, 0))

[KMac]

It worked perfectly. In fact, after you provided this I was able to expand the expression to multiply and divide the results to get an overall percentage.

Thanks Again!!!!

[KMac]

OK, new question: I have a query and the report (mentioned above) runs based on the results of the query. Everything works great now after the help provided above.

But, now I copy the query and the report. I set the Record Source for the report to the Copy of Query and when I open the report it asks twice for Parameters. I can not figure out why. I amke no chanes to either the copied report or query except pointing the copies report to the copies query.

[pbaldy]

If you open the query copy does it prompt? Somewhere must be a reference that includes the query name, so let's figure out whether it's in the query or report.

[KMac]

Nope, no prompt when I open or execute the query. But, as soon as I open the rport I get two parameter prompts on fields that are not included anywhere in the query or the report

[pbaldy]

Sometime they hide in Sorting and Grouping. If not, can you post the db here?

[RayMilhon]

Sometimes Access is sneaky that way.