Sorting/Grouping

[vise]

Hi All,

I have a table in Access that I wish to sort and then group. The fields are as follows: shift, line number, and number of errors. I want to sort by shift; group by line numbers( [1,2,4 - sealing];[3,5,6,9 - grouting]; [7,8,10 - locking]), and number of errors per groups. I wish to create a graph according to the number of errors per shift and grouped line. I tried using the wizard in access, to no avail, I can't seem to get the line numbers to group. Thanks for your help!
I want something as such, if possible:

# of errors
|
| each colum represents a group of lines.
| |
| || |
| || || ||
|__|||__|||_____|||__________
8-4 4-12 12-8
Shift
-vise

 

[JeremyNYC]

You've posted this same thing in two forums. Crossposting is generally frowned on. I assume you did this because you didn't know that, not because you didn't care, so I'm not trying to make you out as a bad guy. I'm just tyring to point out to others that this is posted in another forum, so that they don't waste their time answering it here, in case it's been answered in the other forum.

If you want, I'm sure people wouldn't mind if you posted back with the thread number for the other thread you started, so that they could link to it straight from here.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Professional Development for Clients Large and Small

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[vise]

i'm sorry i did not know.
I will restrain my posts to one forum. I see that some people respond/read other forums more often than others, this is why I did this, also I figured different people might frequent it who could solve this problem. Once again, I'm sorry. What would you reccomend to getting help on an issue from other people that aren't reading the forum i posted on, but are reading the other forums?
Thanks,
-vise