Jump to content
Sign in to follow this  

Difficult find Involving Summary Field(s)

Recommended Posts

My database tracks attendance and enrollments where we have many schools in one program. Not unlike the relationship of schools to a district. Our students however transfer between these schools frequently. They can be in one school for one day then another for a month then another for a week and so forth. Each time a student enters a new school a new enrollment/attendance record is created. I track the total number of days the student is enrolled in each school and then on a summary report, I report the total number of days a student is enrolled in the program/(district). I need to separate and report on students who have been enrolled in our program for 90 days or more. There are many students who have multiple enrollments.

I have tried several methods but none seem to work. I've tried to do simple finds on the summary field but of course you can't do that. I've tried scripts with "set variables" and/or "set fields", with and without loops but nothing seems to work. I'm hoping that someone has come up with a way to search on Summary Fields.

I want to thank Soren Dyhr for his help and advice which I am using in a total redesign of my system. In this case separating enrollments and attendance and more but for now, it is what it is. Thanks in advance for any help.

Share this post

Link to post
Share on other sites

You could use a calculation field to sum the days over a relationship. If you have a Students table, it could be there, or it could be in Enrollments, using a selfjoin on StudentID.

Share this post

Link to post
Share on other sites

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
Sign in to follow this  


Important Information

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