A Amy Guest Dec 1, 2000 #1 I have an Age field that has 4 possibilities (21-30, 31-40, 41-50, 50+). In the report, I want to list 21-30 = count of members 21-30, 31-40 = count of members 31-40, etc. How do I accomplish this (please)?
I have an Age field that has 4 possibilities (21-30, 31-40, 41-50, 50+). In the report, I want to list 21-30 = count of members 21-30, 31-40 = count of members 31-40, etc. How do I accomplish this (please)?
J Jack Cowley Registered User. Local time Today, 00:51 Joined Aug 7, 2000 Messages 2,639 Dec 1, 2000 #2 Put an unbound text box in the Report Footer or where ever you like and set its Control source to: =DCount("[Age]","YourTable","[Age] = '21-30'") Do this for the other 4 groups of dates and you should be good to go....
Put an unbound text box in the Report Footer or where ever you like and set its Control source to: =DCount("[Age]","YourTable","[Age] = '21-30'") Do this for the other 4 groups of dates and you should be good to go....
