grouping records

K

kmcgee

I have a query that looks similar to the one below. I need to combine, for example, 100-112 together and 138-230 together and average the percents. What is the easiest way to do this? :

110 Percent of X Pecent of Y Percent of Z
112 "" "" ""
138
200
230
340
360
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

grouping at custom intervals 2
Deleting records in a table based on criteria 1
Prevent duplicate groups of records in a table 1
Combine Two Queries in Different Layouts 2
CDO Email Default Settings 5
Need help with this 3
Problem with my code...for each loop 4
Combining records 3

Top