I've found the workaround for this issue, but don't understand why it was an issue:
I did all the hard work of writing the queries in Access and some of the queries involve sub-queries
e.g. Pretend I wanted queries that prepared data on Goals, Assists, Wages, Corners
So inside Access, the...