Counting problem in a report.
Edit: Woops, I already answered the first question, (dopey me) I should probably repost this one but I also need to know:
I have a report with headers for ProgramID (the program the Family Attends); FamilyID Header (names of Families) and then in the Detail, I have Children. The report generated tells us every Family that has been in each "Program" and for each family lists their children.
I would like to count the total number of families and children that attend each Program, but a family (kids too) may particiapte in more than one program . I cannot figure out what to count. If I count familyID in the ProgramID Footer, it counts the total times that family has been in any program (if the same family is in program 1 and 5, the count is 2 for that family -- e.g., if family Jones is also in Program 6, the count for Program 1 above is 4 (1 for each of the first 2 familes and 2 for the Jones family) I must be counting the wrong thing.
Edit: Woops, I already answered the first question, (dopey me) I should probably repost this one but I also need to know:
I have a report with headers for ProgramID (the program the Family Attends); FamilyID Header (names of Families) and then in the Detail, I have Children. The report generated tells us every Family that has been in each "Program" and for each family lists their children.
I would like to count the total number of families and children that attend each Program, but a family (kids too) may particiapte in more than one program . I cannot figure out what to count. If I count familyID in the ProgramID Footer, it counts the total times that family has been in any program (if the same family is in program 1 and 5, the count is 2 for that family -- e.g., if family Jones is also in Program 6, the count for Program 1 above is 4 (1 for each of the first 2 familes and 2 for the Jones family) I must be counting the wrong thing.
Last edited: