Jump to content
Salesforce and other SMB Solutions are coming soon. ×

calculate days


B. Scholts

Recommended Posts

At school we have a filemaker pro database that tracks student attendance. We register absence of a student per lesson with a max. of 8 lessons (= 8 records) a day. In case a student misses 24 lessons we will have 24 records. But this absence can be spread over 3 to 6,7 days. Is there a way to calculate the number of days a student is not at school?

Link to comment
Share on other sites

It depends on how you have set up the attendance records. I suppose what you are looking for is where there are eight records in a single day to count as one day absent? But you would not want to count last four lessons from one day and first four from the next as absent?

 

It really depends on what your business rules are? Any ideas?

Link to comment
Share on other sites



×
×
  • Create New...

Important Information

Terms of Use