The first thing I would do is to stop using totg in other expressions. I always use the expression and not the derived column.
Substitute Count([Matches for grid - league].id) for totg.
I'm sure there are other ideas but I need time to digest this.
Sent: Monday, November 7, 2016 9:29 AM
Subject: Re: [MS_AccessPros] Query not responding
FROM [Matches for grid - league]
WHERE (((Month([date]))<>5) AND (([Matches for grid - league].Refid)=[forms]![Live Games]![referee]))
GROUP BY [Matches for grid - league].Season
ORDER BY [Matches for grid - league].Season DESC;
Posted by: Duane Hookom <firstname.lastname@example.org>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (8)|