Jump to content
Sign in to follow this  
Veronica

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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