Making Query Load faster?

[Crash1hd]

Can anyone sugjest a way to make this query load faster when there is a lot of data?

SELECT Round(Avg([Percentages_Inbound]![Percentage_Both_In])) AS Inbound, Round(Avg([Percentages_Outbound]![Percentage_Both_Out])) AS Outbound, (([Inbound]+[Outbound])/2) AS CCC, Round(Avg([Percentages_Data]![Percentage_Both_Data])) AS Data, Round(Avg([Percentages_Helpdesk]![Percentage_Both_Helpdesk])) AS Helpdesk, Round(Avg([Percentages_IRO]![Percentage_Both_IRO])) AS IRO
FROM Percentages_Inbound, Percentages_Outbound, Percentages_Data, Percentages_Helpdesk, Percentages_IRO;

 

[Crash1hd]

So more like this

SELECT Round(Avg([Percentages_All].[Percentage_Both_In])) AS [Inbound%], Round(Avg([Percentages_All].[Percentage_Both_Out])) AS [Outbound%], (([Inbound%]+[Outbound%])/2) AS [CCC%], Round(Avg([Percentages_All].[Percentage_Both_Data])) AS [Data%], Round(Avg([Percentages_All].[Percentage_Both_Helpdesk])) AS [Helpdesk%], Round(Avg([Percentages_All].[Percentage_Both_IRO])) AS [IRO%], (([Inbound%]+[Outbound%]+[Data%]+[Helpdesk%]+[IRO%])/5) AS [ADT%]
FROM Percentages_All;

 

[Crash1hd]

Ok well that did speed it up, and it is much faster now