Jump to content
Sign in to follow this  
Ben Feingold

How do I count text?

Recommended Posts

I have two databases: Behavior & Classes

In the "Behavior" database I have a text field entitled Consequence where the staff chooses one of four possible consequences from a drop down: Time Out, Dismissal, EDR or Assessment.

In the "Classes" database I have four number fields that correspond to the consequences above. I would like for those fields to tally the total number of each consequence for each student.

Any thoughts?

Ben Feingold

Dearborn Academy

Arlington, MA

Share this post


Link to post
Share on other sites

You need to create a summary field for each of the four consequences. Then, assuming that you have relation between the files, you would put each of those fields on the student layout. They will sum correctly for each student!

Share this post


Link to post
Share on other sites

Hi,

In Behaviour, create 4 calculations with these boolean formulas

cTimeOut --------Consequences ="Time Out"

cDismissal ------Consequences ="Dismissal"

cEDR --------------Consequences ="EDR"

cAssessment -- Consequences ="Assessment"

Then in Classes, with a relationship StudentID::StudentID

cTimeOut_u = Sum(BehaviourByStudentID::cTimeOut)

cDismissal_u= Sum(BehaviourByStudentID::cDismissal)

cEDR_u=Sum(BehaviourByStudentID::cEDR)

cAssessment_u=Sum(BehaviourByStudentID::cAssessment)

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.