Lougee Posted September 7, 2006 Share Posted September 7, 2006 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 More sharing options...
John Mark Osborne Posted September 7, 2006 Share Posted September 7, 2006 Have you tried creating a subsummary report yet? Link to comment Share on other sites More sharing options...
Lougee Posted September 8, 2006 Author Share Posted September 8, 2006 Seems I was looking at this from the wrong direction -- from contacts to activeYears. It works when I use a layout based on activeYears. I have a LOT to learn, believe me! And I thank everyone for their patience and help. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6574 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 accountSign in
Already have an account? Sign in here.
Sign In Now