Hi There, I hope you can help me.
I am designing and administering a databas for a charity which needs to provide information on attendance figures to its trustees, using Microsoft Access 2002.
My particular problem is I need to produce a report that gives an age range split of attendees over a given time period, say a month.
A single person can attend multiple times in a given time period, but for the purpose of the required report this persons presence in that time period needs only to be counted once.
I have designed a grouped report that gives the following information;
(note : indentation implies group level in the report.
AGE RANGE
NAME LIST
ie it appears as
20s
J.Bloggs Attended 4 times
M.Stevens Attended 6 time
30s
A.Higgins Attended 5 times
C.Huges Attended 3 times
N.Cave Attended 6 times
Etc
What I want to be able to do is for each age range, calculate a sum of attendance for DISTINCT persons, so the sum I want for the 20s age range would be 2, and for the 30s age range would be 3.
Is there any way I can do this?
I hope you can help me, and I hope you don’t consider this a trivial problem, as i am self taught and tend to try to learn as I go.
Thanks
Geoff