Access Web App query 3 Tables with aggregatios - Need a workaround
I have one workaround going which is making a seperate query for each 1:n-relation which connects DNS and SUM(foo) and one query which has the results of all the queries. Then in the little ERM for the query I connect every DNS entry of the queries.
For 1:1 relations in the DB I can just use the standard table in the overallQuery.

still looking for other workarounds though