Jump to content

collecting summary data


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

Recommended Posts

I'm tracking student participation in an after-school club for a grant-funded program and funders require lots of statistics to back up our reports such as the number of years students (and faculty) stay in the program.

I have a 'contacts' table with basic information (name, address, contactID#)and participation information in an 'activeYears' table with one record/person/year related by contactID. A portal on the 'contacts' layout shows member participation -- one record/year. Works great.

Now I need to summarize the information shown in the portal -- in other words, show total years each person has participated. That's easy too; 2 fields in 'activeYears' -- one to count the years such as -- if (active = "yes", 1,0) and then a summary field 'yearsTotal' will give me the total years by member. Placing 'activeYears::yearsTotal) on my contacts layout shows exactly that.

The problem comes when I want to search for members with 4 years partipation or 7 years or 11 years -- you get the idea. I can't search in a summary field and I can't get totals in the 'activeYears' table.

What am I doing wrong/not understanding/missing?

Link to comment
Share on other sites

This topic is 6464 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.