Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About fmdummy

  • Rank
  1. Summarizing Portals

    Thanks for the reply John, but I'm familiar with subsummary reports. Unless I'm missing something really obvious (which is possible), I don't think I can get what I need with a simple subsummary. As shown in the picture I attached, the a count of the rankings need to be totaled by Studio and Ranking Number, which gives a 9x9 matrix. I appreciate any help. Thanks.
  2. Summarizing Portals

    Hopefully I can explain what I'm trying to do clearly. The table I'm working with has records for each student. There is a portal in this layout that lists what number the student ranked each studio. It will always be ranked 1-9. So the portal just contains the field Rank and Studio. What I need to do is summarize a count of how many people ranked each studio 1,2,3,4,5,6,7,8, or 9. The other problem is that I want this at the end of a layout. The report above it is a listing of each student and their respective studio rankings. I attached a picture of how it looks now which is how I want it to look. But I had to create 162 fields just for the totals to work. And I have to change them every year when the studio names change. I figured there's a better way. Thanks for you help. I've been trying to figure this out for a couple months and haven't gotten anything that wasn't really messy.

Important Information

By using this site, you agree to our Terms of Use.