November 19, 2008 02:32am pst

1. LSMCons... 221,794
2. boag2000 207,288
3. capricorn1 173,245
4. DatabaseMX 113,861
5. peter57r 100,815
6. matthews... 61,295
7. harfang 55,490
8. jimhorn 51,658
9. jmoss111 46,537
10. GRayL 27,259
11. LennyGray 25,605
12. JDettman 25,023
13. hnasr 24,075
14. frankytee 18,250
15. MikeToole 16,650
16. RgGray3 15,896
17. kelvinsparks 15,490
18. mbizup 15,450
19. jefftwilley 15,400
20. wiswalld 14,660
21. dqmq 13,287
22. Arthur_... 12,882
23. clarkscott 12,710
24. nexusnation 12,400
25. cactus_d... 12,394

1. LSMCons... 286,909
2. capricorn1 216,253
3. boag2000 215,263
4. DatabaseMX 189,219
5. peter57r 143,269
6. matthews... 89,629
7. jimhorn 75,676
8. harfang 74,470
9. jefftwilley 61,168
10. jmoss111 51,137
11. GRayL 47,691
12. JDettman 45,298
13. frankytee 35,142
14. mbizup 31,050
15. MikeToole 30,650
16. dqmq 29,647
17. LennyGray 25,605
18. kelvinsparks 24,990
19. hnasr 24,075
20. stevbe 21,852
21. puppydog... 21,045
22. LPurvis 20,873
23. rockiroads 19,250
24. Arthur_... 16,982
25. wiswalld 16,390

07.23.2008 at 01:30PM PDT, ID: 23590095

	[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!

6.6

Retrieve lowest value form multiple fields in Access Table

Asked by qtrmile69 in Access Architecture/Design

I have a Dart League Database I have inherited... My question is I have a Query, based on the PlayerStats table that is supposed to return results of the lowest PPD (Points Per Dart) in a single game (P1, P2, P3, P4) P= Game...

The query I would like to be able to get would be to show from those four fields what was the lowest value >0..

So ... PlayerStats table has the PPD per game. Player table has Player Name.

I have tried various functions, and researched for finding lowest value among multiple tables, but have come up a little short.

The basic result would be display player name, and the lowest PPD form those four fields.

So I am back at the beginning with the original code:

SELECT Player.Name, PlayerStats.P1, PlayerStats.P2, PlayerStats.P3, PlayerStats.P4
FROM PlayerStats INNER JOIN Player ON PlayerStats.PlayerID = Player.PlayerID;
Start Free Trial

Keywords: Retrieve lowest value form multiple fiel…

	Title
1	P3 vs P4
2	Upgrading my P3 to P4
3	P3 + p4 on a dual processor. Supp…
4	SQL Syntax to select lowest price /s…
5	Inner join and aliases
6	Select Record with lowest & Highest v…

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Retrieve lowest value form multiple fields in Access Table

Asked by qtrmile69 in Access Architecture/Design

About this solution