Recent content by cmrobinson

This is weird, because I do the exact same thing and I get doubling totals. This is what mine looks like. Data: Course CRN Students Tuition x 1234 10 100 x 1236 10 100 y 2345 20 200 z 3456 10 150 z 3458 10 150 PivotTable: Sum of Amount Course Total x 4000 y 4000 z 6000 Grand Total 42000...

Thanks all. Here is an example of my data and what results I am after. Course Section Max Students Tuition X 1234 10 $100 X 1236 10 $100 Y 2345 20 $200 Z 3456 10 $150 Z 2458 10...

SkipVought and tav1035, Thanks for the ideas but I guess I missed one important aspect of my problem. I may have several sections of the same course. So I may have 3 different rows for course X, all unique in the number of students they have. It works great if I only have one record per...

Hello all, I am using a PivotTable to generate totals. The problem is that it is doubling the totals on me. I create a formula from my fields and when I have more than one line of the same item, it is doubling the sum of the formula. For Example: Course X Max students 10 Course tuition 100...

All, I have a strange little problem that I am sure there is an answer for. I am trying to do a simple concatenation on a Report (just like I would do it on a form or query) and it will not work. Basically I am trying to concatenate a Firstname and Lastname field from a members table. This...

Does anyone know of a way to keep sheets grouped versus having Excel ungroup them once you click on a single sheet? There was a funtion like this in Lotus 123 and I am trying to find the equivalent? Thanks! Carrie