Help with a Query Issue

tjb123

New Member
Joined
Mar 25, 2011
Messages
4
I'm new to Access and need some help with some data manipulation.

I have a database that tracks 8,000 unique individuals' participation in a series of 35 events. Not all individuals will participate in these events. There is one table that holds all of the data. Each of the 35 events has a check box to indicate participation.

I need to run a query or report that provides me with a list of people who particpate in one or more events (I want a total count of unique participants).

I have tried running a parameter query but I run out of space for the "or" statements since there are 35 unique events. How can I create this report and thanks in advance for your help. I really appreciate it.
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

revans

Well-known Member
Joined
Apr 5, 2010
Messages
576
It seems you have a normalization problem. I was just reading Roger's blog which is covering this issue. Perhaps that might help.

hth,

Rich
 

boblarson

MrExcel MVP
Joined
Nov 14, 2008
Messages
1,964
Please don't tell me that your events table has a column for each event. Your persons/events table should have a ROW for each event. Your table structure should be something like this:

tblEvents
EventID - Autonumber (PK)
EventName - Text


tblPersons
PersonID - Autonumber (PK)
FirstName - Text
LastName - Text
...address and such

tblPersonsEvents
PersonEventID - Autonumber (PK)
PersonID - Long Integer (FK from tblPersons)
EventID - Long Integer (FK from Events)
 

Watch MrExcel Video

Forum statistics

Threads
1,108,819
Messages
5,525,080
Members
409,618
Latest member
gkllc

This Week's Hot Topics

Top