Jump to content

Separate Summaries


jludwig

This topic is 7304 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I've got a student db, an assignments db, and a grades db. I have a many to many relationship between the Students and Assignments, and I store the grades in the grades db. The school program is broken into 4 blocks, and several areas in each block, which need an average grade each. I need to be able to get an average grade for each student for each area of each block. Is this making any sense? I can get a summary field to work for all grades per student, but that isn't what I need. Each part of each block, (several summary type fields) needs a summary of it's own.

Please help!

Version: v6.x

Link to comment
Share on other sites

Hi and welcome to the forums.

If I understand correctly, you could create a concatenated field of Student & "_" & Block & "_" & Area. Create a subsummary part based on this field and sort your records by the three fields comprising it (Student, Block, Area). Any summary fields placed in this part should summarize based on the concatenated result.

If I've missed the question, let me know. smile.gif

Link to comment
Share on other sites

Where are the Blocks being stored? How does a Block relate to a Student?

It might help if you could attach a sample file (zipped or stuffed) of your three dbs so I can get a better idea of the structure.

Link to comment
Share on other sites

I think it would help a lot if the Block-Areas were assigned to their own db. Then you can use a version of the calculation field I suggested above. The way it is currently seems like it will take many extra calculations (one for each block-area and a summary for each calc).

Link to comment
Share on other sites

This topic is 7304 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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