Hall of Fame

1. capricorn1507,479
2. DatabaseMX301,438
3. LSMCons...225,216
4. matthews...149,908
5. peter57r111,733
6. GrahamM...108,016
7. JDettman89,659
8. GRayL82,500
9. puppydog...74,770
10. Helen_Fe...69,064
11. cactus_d...56,052
12. thenelson54,468
13. JezWalters47,416
14. SimonAdept46,307
15. fyed44,584
16. Torrwin44,370
17. hnasr37,910
18. kelvinsparks37,252
19. HainKurt35,786
20. Bitsqueezer32,537
21. OxonDev29,675
22. harfang26,090
23. ErezMor24,650
24. Tramtrak23,890
25. tbsgadi22,021

1. capricorn113,713,472
2. DatabaseMX6,593,549
3. rockiroads6,053,947
4. nico50385,705,281
5. LSMCons...5,651,097
6. peter57r5,258,340
7. LPurvis3,656,859
8. GRayL3,393,362
9. harfang3,386,745
10. shanesue...3,288,317
11. stevbe2,861,511
12. boag20002,812,505
13. jimhorn2,808,217
14. matthews...2,701,182
15. mbizup2,388,890
16. thenelson2,344,970
17. flavo2,117,383
18. jadedata1,968,277
19. puppydog...1,962,886
20. jefftwilley1,898,620
21. cactus_d...1,758,344
22. JDettman1,595,751
23. eghtebas1,548,179
24. jjafferr1,344,995
25. dannywar...1,330,887

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

7.8

Need to remove warning "Enter Parameter Value"

Asked by IUfoltzie in Microsoft Access Database

Tags: parameter

Here is the SQL, I get the "Enter Parameter Value" popups for the Sum of Sum of month requests and the sum actuals line. Data entered into the box is not used. Points go to whomever can help me figure out why and remove them, extra points can be giving if this can be slimmed down a bit (which I assume it can, this was quick and dirty and I havent had time to clean it up yet)

SELECT DISTINCTROW tbl_cost_piw_title_type.[Work Type], tbl_cost_piw_title_type.Project_Application, tbl_cost_piw_title_type.[Cost Group ID], qry_CMPM_enhancing_FTE.[Cost Group ID], qry_CMPM_enhancing_FTE.PIW, Sum(qry_CMPM_enhancing_FTE.[Sum Of January]) AS [Sum Of Sum Of January], Sum(qry_CMPM_enhancing_FTE.[Sum Of Febuary]) AS [Sum Of Sum Of Febuary], Sum(qry_CMPM_enhancing_FTE.[Sum Of March]) AS [Sum Of Sum Of March], Sum(qry_CMPM_enhancing_FTE.[Sum Of April]) AS [Sum Of Sum Of April], Sum(qry_CMPM_enhancing_FTE.[Sum Of May]) AS [Sum Of Sum Of May], Sum(qry_CMPM_enhancing_FTE.[Sum Of June]) AS [Sum Of Sum Of June], Sum(qry_CMPM_enhancing_FTE.[Sum Of July]) AS [Sum Of Sum Of July], Sum(qry_CMPM_enhancing_FTE.[Sum Of August]) AS [Sum Of Sum Of August], Sum(qry_CMPM_enhancing_FTE.[Sum Of September]) AS [Sum Of Sum Of September], Sum(qry_CMPM_enhancing_FTE.[Sum Of October]) AS [Sum Of Sum Of October], Sum(qry_CMPM_enhancing_FTE.[Sum Of November]) AS [Sum Of Sum Of November], Sum(qry_CMPM_enhancing_FTE.[Sum Of December]) AS [Sum Of Sum Of December], Sum(qry_CMPM_enhancing_FTE.[Sum Of YTD Regular]) AS [Sum Of Sum Of YTD Regular], [Sum Of Sum Of January]+[Sum Of Sum Of Febuary]+[Sum Of Sum Of March]+[Sum Of Sum Of April]+[Sum Of Sum Of May] AS Sum_Actuals, (([Sum_Actuals]/152)/5) AS AVG_YTD_Actuals
FROM (qry_CMPM_enhancing_FTE LEFT JOIN tbl_cost_group ON qry_CMPM_enhancing_FTE.[Cost Group ID] = tbl_cost_group.[Cost Group ID]) RIGHT JOIN tbl_cost_piw_title_type ON qry_CMPM_enhancing_FTE.[Cost Group ID] = tbl_cost_piw_title_type.[Cost Group ID]
GROUP BY tbl_cost_piw_title_type.[Work Type], tbl_cost_piw_title_type.Project_Application, tbl_cost_piw_title_type.[Cost Group ID], qry_CMPM_enhancing_FTE.[Cost Group ID], qry_CMPM_enhancing_FTE.PIW, [Sum Of Sum Of January]+[Sum Of Sum Of Febuary]+[Sum Of Sum Of March]+[Sum Of Sum Of April]+[Sum Of Sum Of May], (([Sum_Actuals]/152)/5)
ORDER BY tbl_cost_piw_title_type.[Work Type], tbl_cost_piw_title_type.Project_Application;

Thanks EE!

View the Solution FREE for 30 Days

20100315-EE-VQP-143

Need to remove warning "Enter Parameter Value"

Asked by IUfoltzie in Microsoft Access Database

Tags: parameter

About this solution