I need and will appreciate any help with this. I'm sure I'll have to clarify but here's a start to explaining my problem.
Running MS Office 365. When running this query, we get 'System Resources Exceeded' error message from MS Access. Table T1 has 11,000 records, T2 has 43,000 records, and T3 has 670,000 records.
Running MS Office 365. When running this query, we get 'System Resources Exceeded' error message from MS Access. Table T1 has 11,000 records, T2 has 43,000 records, and T3 has 670,000 records.
SELECT T1.F1, T1.F2, T2.F1, T2.F2, T2.F3, T2.F4, T2.F5, T2.F6, T2.F7, T2.F8, T2.F9, T3.F1, T3.F2, Sum(T3.F3) AS SumOfF3, T3.F4 |
FROM T1 RIGHT JOIN (T3 INNER JOIN T2 ON T3.F2 = T2.F2) ON T1.F2 = T2.F9 |
GROUP BY T1.F1, T1.F2, T2.F1, T2.F2, T2.F3, T2.F4, T2.F5, T2.F6, T2.F7, T2.F8, T2.F9, T3.F1, T3.F2, T3.F4 |
HAVING (((T3.F1)="32") AND ((T3.F4)>=[Enter Month])); |