Categorizing My Report..

[drblackard]

Hey! I have searched the forum and I know there is something out there to help me but I can not find it....let me pick someones mind a little...this is probably really simple but I am having problems getting it to work for me....I think I am making it bigger than what it is ..... so here it goes:

I have a report that I am tracking training hours for employees. I have their training hours, dates they trained, LastName, Firstname, and any notes that were recorded.....I have queried the report and got the names together however what I would like to do is categorized all training for one employee under their name and then give total training hours then the next....I have beat myself up with this and i have done it before but can't seem to find the old report....I think I am overlooking something simple but am looking for a clear thinking mind..thanks in advance for your help....

 

[Rich]

Use the Group by option on the toolbar to add a group for employee

 

[drblackard]

Thanks Rich ... but I don't have that option or I am not looking in the right place...I selected the report and went to design view...the only sorting that I have is Last Name and First Name to get the groups and it does group them but they are all listed individually...I must be doing something wrong...but I don't see the option on the toolbar to "Group by"....

 

[drblackard]

I think I got it another way...now can someone help me with the SUM of the training hours in the report for each person...