Apply conditions to totals row in query

[Kozbot]

Hello

I have a parameter query with a totals row that displays averages. Is there a way to have the average row use only specific records in its calculation based on one of the field's values WHILE still displaying all the records returned by the query.

I want only data that has a "YES" value used in the average while still displaying the records marked as "NO"

 

[Beetle]

Depending on exactly what it is you're doing, you might be able to use an IIf statement in the calculation, something like;

IIf([SomeField] = "Yes", YourCalculationHere, "")

Or, you might use DAvg

DAvg("[SomeField]", "[SomeTable]", "[SomeOtherField] = 'Yes'")