Duplicate Entries on a Report

  • Thread starter dwaynesworld013
  • Start date
D

dwaynesworld013

I have created a report where the courses taught are listed for a particular
timeframe. Included in this report are the following fields:
CourseName, TotalParticipants and TotalCourseHours (calculated field)

The problem that I am having is that I would like to avoid listing a class
twice if the course was taught more than once in the month. BUT, I would
like to have the total participants and total course hours calculated for the
total number of courses taught for that period. Here is what I have now:

Course Name Total Participants Total
Course Hours
Course 1 10
20
Course 1 5
10
Course 2 5
40

This is what I would like for the report to look like:

Course Name Total Participants Total
Course Hours
Course 1 15
30
Course 2 5
40

Can anyone help me? Thanks
 

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