Subtraction in an Aggregate query

[JimO]

I have a list of baseball opponents that shows the number of games scheduled and the number of games played. The [Count of Opponet] being scheduled games and [SumOfGameCount] the completed games. I keep getting errors. How can I get this to work in an aggregate query?

Remaining:=Sum( [CountOfOpponet] - [SumOfGameCount] )

Jim O

[pbaldy]

For starters, in a query you wouldn't want the =.

[JimO]

Thanks, I am still getting a message Subqueries cannot be used in the expression(Remaining:Sum( [CountOfOpponet] - [SumOfGameCount] ).

Jim O

[JimO]

Got it to work.

Remaining:[CountOfOpponet] - [SumOfGameCount]

Jim O