Duplicate Values Comparison table / report

[pattyjean]

I have built multiple queries and crosstabs and then merged them back into a make table query
The data looks like this:

Learning courses......................Equilvant course
Make Table

Course Section Location Ttl Pass Fail Course ttl PASS FAIL
ABC123 1234 Campus1 100 80 20 ABC123 200 150 50
ACD123 1235 Campus2 80 60 20 ACD123 150 75 75
ACD123 1236 Campus3 50 30 20 ACD123 150 75 75
ACD123 1237 Campus3 50 30 20 ACD123 150 75 75
*need to delete the bolded data
I need to make a report with the totals by course. I only need the first equilvant course data for ACD123 BUT because I matched in a query it pulls the data twice. How can I just keep one record for each of the equilvant courses while keeping ALL OF the learning courses and section numbers?
When I built a report I deleted the duplicate records for testing purposes- I left the detail out on the equivalant and used a group header for the course. Sometimes the course shows and sometimes it doesn't. Any advise?
Please let me know if you need more details.

 

[Remou]

Would you be satisfied with grouping on equivalent course? It would be by far the easiest, your data would look vaguely like this:

[tt]
Course Section Location Ttl Pass Fail
--------------------------------------
Equivalent
Course ttl PASS FAIL
ABC123 200 150 50
--------------------------------------
ABC123 1234 Campus1 100 80 20
--------------------------------------
Equivalent
Course ttl PASS FAIL
ABC123 150 75 75
--------------------------------------
ACD123 1235 Campus2 80 60 20
ACD123 1236 Campus3 50 30 20
ACD123 1237 Campus3 50 30 20[/tt]

http://lessthandot.com

 

[pattyjean]

I put the Equivalent in the group header and the other sumed up total. I need the courses summed up a level. I also have two higher headers that need totals by department and academic group.
I deleted the dups(manually) after making the table. So today I will try to just put the equivalent back in the details of the report.

I will try your idea but I still need the totals.