Please help me understand why I get the following error message when trying to execute a query using this expression:
ERROR MESSAGE
You tried to execute a query that does not include the specified expression " as part of an aggregate function.
EXPRESSION
Expr1: (SELECT [Daily Goal] FROM [DailyProductionGoal] WHERE [qryStreamFactor].[ProductionMonth]=[DailyProductionGoal].[ProductionMonth] AND [qryStreamFactor].[ProductionYear]=[DailyProductionGoal].[ProductionYear])
Thanks for your help.
ERROR MESSAGE
You tried to execute a query that does not include the specified expression " as part of an aggregate function.
EXPRESSION
Expr1: (SELECT [Daily Goal] FROM [DailyProductionGoal] WHERE [qryStreamFactor].[ProductionMonth]=[DailyProductionGoal].[ProductionMonth] AND [qryStreamFactor].[ProductionYear]=[DailyProductionGoal].[ProductionYear])
Thanks for your help.