Access aggreage function error

[Guest]

I am trying to run some reports off my database queries. Each record in the
report is a different player's stats for a particular game. For the report
footer, I would like to post the total stats of all players combined.
Everything is ok, except 2 fields. I realize that they are strange, but I got
them working in Excel but not for Access. I get the "You tried to execute a
query that does not include the specified expression 'Game' as part of an
aggregate function. The first one is:

Ratio Totals: ([Tackles]+[Assists]+[Tackles For
Loss]+[Sacks]+[Pressures]+[Hits On QB]+[Passes Broken Up]+[Caused
Fumbles]+[Recovered Fumbles]+[Effort Plays]+[Interceptions]+[Touchdowns]) &
"-" & [Total Plays]

When I try to Sum those i get the error. How can i prevent this.

 

[S.Hoitinga]

two suggestions come up:

1. get rid of the space in the field you're trying to calculate (Ratio
Totals should be RatioTotals)
2. the last field you concatenate to your calculation (Total Games) seems an
aggregate field.
Add the field Game in the query that calculates your Total Games field.
(Better even to name it TotalGames but anyway add the field Games in the
query)

Hope this helps

Sybolt