G
Guest
Please bear with me, as I am very new to access.
I have a table that consists of part numbers, class numbers and total
rejects (see sample table1). I would like to sum all the total rejects
based on class number (see table 2). Any information on how to do this would
be
greatly appreciated. Also, if anyone knows of a good place to learn more
about access.
Thanks, Sandy
Sample Table 1
Part # Class # Total Rej
12 23 10
53 24 15
45 23 8
10 24 5
Sample Table 2
Class # Total Rej
23 18
24 20
I have a table that consists of part numbers, class numbers and total
rejects (see sample table1). I would like to sum all the total rejects
based on class number (see table 2). Any information on how to do this would
be
greatly appreciated. Also, if anyone knows of a good place to learn more
about access.
Thanks, Sandy
Sample Table 1
Part # Class # Total Rej
12 23 10
53 24 15
45 23 8
10 24 5
Sample Table 2
Class # Total Rej
23 18
24 20