Group Counts/Sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I have built a query from two tables.

I have the following headings:
Group #, Group Desc, Book, Training, Knots

And receive the following results from the query:
37,Instructor,2523,35,31
37,Instructor,2525,45,1
37,Instructor,2526,41,91
38,Owner,2536,89,97 etc...

All I want from this information is the group # and desc to display once,
have a count of the books per group and a total of all training per group and
Knots per group.
ex: 37, Instructor, 3, 121,123

How would I go about doing this? Should I create another query or add on to
the one I have.

Thanks..
 
You need to do a 'Group by' by pressing the Sigma button on the toolbar.
Leave the first two fields as "Group By" and sum each of the last 3 fields.
If your last 3 fields are text fields, then you need to use the val function.
Field Name = Book:val(book).
 
Almost correct, I think the poster will need to use the count function on 3rd
field and SUM on the 4th and 5th.
 
Back
Top