Help with a Query Issue

[tjb123]

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.

 

[revans]

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]

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)

 

[litionna2]

good post!!!thank you!!!