Summing totals from another field from like fields

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
 
A

Al Campagna

Sandy,
Is this sum used on a report or form?
Given the data you supplied, a Totals query can be used to sum the Rejects by Class.
Using the query design grid... place the Class and the Rejects field in the grid, and
then select View/Totals.

Class Rejects
GroupBy Sum
Sort Asc

Would yield...
23 18
24 20

Suggestion: don't use the # symbol in your field names. Use something like PartNo and
Class
Also, avoid spaces in names (ex. TotalRejects)

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
G

Guest

Thanks so much. :blush:)

Thanks, Sandy

Al Campagna said:
Sandy,
Is this sum used on a report or form?
Given the data you supplied, a Totals query can be used to sum the Rejects by Class.
Using the query design grid... place the Class and the Rejects field in the grid, and
then select View/Totals.

Class Rejects
GroupBy Sum
Sort Asc

Would yield...
23 18
24 20

Suggestion: don't use the # symbol in your field names. Use something like PartNo and
Class
Also, avoid spaces in names (ex. TotalRejects)

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 

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

Top