An issue with report design

By Geoff Doyle ·
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.


ie it appears as

J.Bloggs Attended 4 times
M.Stevens Attended 6 time
A.Higgins Attended 5 times
C.Huges Attended 3 times
N.Cave Attended 6 times

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.


This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums