Hi, i have written the following query in access which gives me an "Enter Parameter Value" Popup for SumOfWorkload and SumOfNumber Of OM. Can anybody help me understand why this is.
Thanks in advance.SELECT [13WeeksData].GM, [13WeeksData].[Friendly Queue Name], Sum([13WeeksData].[Number Of OM]) AS [SumOfNumber Of OM], Sum([13WeeksData].Workload) AS SumOfWorkload, [13WeeksData].[Week Start Date], ([SumOfWorkload]/[SumOfNumber Of OM]) AS AHT INTO 13WeeksData_GM_Table FROM 13WeeksData GROUP BY [13WeeksData].GM, [13WeeksData].[Friendly Queue Name], [13WeeksData].[Week Start Date], ([SumOfWorkload]/[SumOfNumber Of OM]) ORDER BY [13WeeksData].GM;
To fix this you must create a second query based upon the first query. Delete the calculated expression "Sum of Workload/Sum of Numbers of OM" in the first query.
Put this calculation expression in the second query. Run the second query and you should be ok as it will draw the data directly from the first query. You do not need to run the first query as it will be prompted by the second query.
This (parameter request) occurs because you have a calculation of aggregated fields and Access doesn't like this.
Hope this helps you out.
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks