1. boag2000 729,401
2. capricorn1 136,203
3. peter57r 132,118
4. LSMCons... 110,705
5. matthews... 86,290
6. TextReport 84,500
7. thenelson 77,903
8. tbsgadi 65,115
9. DatabaseMX 64,382
10. Helen_Fe... 45,591
11. JDettman 42,213
12. harfang 31,726
13. rockiroads 25,600
14. GRayL 25,028
15. kelvinsparks 24,700
16. mlmcc 22,775
17. coffeeshop 16,200
18. puppydog... 16,000
19. mbizup 14,350
20. cactus_d... 14,300
20. sb9 14,300
22. mildurait 13,250
23. jimpen 12,578
24. hnasr 11,707
25. budorat 10,900

1. boag2000 1,341,072
2. capricorn1 378,543
3. LSMCons... 349,127
4. peter57r 345,659
5. DatabaseMX 301,572
6. harfang 198,450
7. matthews... 196,831
8. jefftwilley 168,012
9. jimhorn 145,747
10. GRayL 122,439
11. TextReport 119,416
12. JDettman 113,793
13. thenelson 97,305
14. tbsgadi 91,425
15. eghtebas 89,865
16. mbizup 89,645
17. irudyk 63,596
18. frankytee 61,340
19. omgang 60,682
20. OnALearn... 56,662
21. rockiroads 55,040
22. puppydog... 53,405
23. mlmcc 52,091
24. stevbe 51,181
25. Helen_Fe... 45,591

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

05/16/2008 at 02:47PM PDT, ID: 23409846

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

8.2

How to group fields in a report.

Asked by catkinson in Access Reports, Microsoft Access Database, Access Architecture/Design

Tags: Microsoft, Access, 2000

I have a record set with a field for where buildings are located ([Region]). I'm atempting to make a new report that groups these regions by a more broad field, [Zone]. For example, Region 1, 2, and 4 are in zone A, and region 3 is in zone B. I created a new table, matching the Zones and Regions, and edited the row source to :
SELECT RegionKEY, ZoneCode FROM tblZones ORDER BY ZoneCode

Now the problem: In my new report there are three different heading for Zone B. If i attempt to group by interval Zone B ends up getting mixed in with Zone A.

Is there a way to combine all of the Zone A headings into one? (i.e. one heading for all regions under zone A, and a seperate heading for regions in zone B)

View the Solution FREE for 30 Days

20091028-EE-VQP-88 / EE_QW_2_20070628

How to group fields in a report.

Asked by catkinson in Access Reports, Microsoft Access Database, Access Architecture/Design

Tags: Microsoft, Access, 2000

About this solution