Hi, i hope somebody can help, i have written the following SQL query:
but whenever I run this, it comes up with the Enter Parameter Value error for SumOfWorkload and SumOfNumber and after clicking on both, i get the results i need but just wondering how i can get rid of this...SELECT Workload.Manager, Workload.[Name], Sum(Workload.[Number]) AS [SumOfNumber], Sum(Workload.Workload) AS SumOfWorkload, Workload.[Week Start Date], [SumOfWorkload]/[SumOfNumber] AS AHT FROM Workload GROUP BY Workload.Manager, Workload.[Name], Workload.[Week Start Date], [SumOfWorkload]/[SumOfNumber] ORDER BY Workload.Manager;
Thanks in advance.
Try it like this:
or,SELECT Workload.Manager, Workload.[Name], Sum(Workload.[Number]) AS [SumOfNumber], Sum(Workload.Workload) AS SumOfWorkload, Workload.[Week Start Date], Sum(Workload.Workload)/Sum(Workload.[Number]) AS AHT FROM Workload GROUP BY Workload.Manager, Workload.[Name], Workload.[Week Start Date], Sum(Workload.Workload)/Sum(Workload.[Number]) ORDER BY Workload.Manager;
Cheers,SELECT Workload.Manager, Workload.[Name], Sum(Workload.[Number]) AS [SumOfNumber], Sum(Workload.Workload) AS SumOfWorkload, Workload.[Week Start Date], Sum(Workload.Workload)/Sum(Workload.[Number]) AS AHT FROM Workload GROUP BY Workload.Manager, Workload.[Name], Workload.[Week Start Date], AHT ORDER BY Workload.Manager;
Last edited by ConneXionLost; 03-24-2011 at 03:11 PM.
“To sin by silence when they should protest makes cowards of men.” ~ Abraham Lincoln
ConneXionLost, thanks, will try these and let you know how i get on. Thanks for your help.
Try the solution in upper post.
This error may also occur when the field name is misspelled or not present in a query, table.
This is helpful when you want to specify some perimeter at runtime. Just enter the name not present in the table / query
Regards
Mahju
Mark the thread as solved if you are satisfied with the answer
Rule 9
Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks