I am trying to develop a query called "ro2" based on the values of two fields: R SO2 R, R SO2 L
The query returns an error saying "You tried to execute a query that does not include the specified expression 'ro2: IIf([R S02 L] Is Null,[R S02 R],Avg([R S02 L]+[R S02 R]))' as part of an aggregate function"
The query i am trying to use is below. it should say that: if "R SO2 L" is missing, use "R SO2 R", if not, use the average of the two values.
ro2: IIf([R S02 L] Is Null,[R S02 R],Avg([R S02 L]+[R S02 R]))
Any help would be great.
Thank you,
Donny