query multiple fields

[scott]

I have a table containing names and events. There are
four events (event1, event2, event3, event4) fields that
contain either a 0 or the number attending for that
event. I want to have a query that I can use for mailing
labels that checks to see if they are attending any of
the events and creates a label. I do not want to have
multiple labels for the same person (because they are
attending more than one event), so it must check all four
fields and print the name, address, etc. if attending one
or all of them.

 

[John Vinson]

I have a table containing names and events. There are
four events (event1, event2, event3, event4) fields that
contain either a 0 or the number attending for that
event.

You're aware, I hope, that this is an improper, denormalized design?
What if there were a FIFTH event?

I want to have a query that I can use for mailing
labels that checks to see if they are attending any of
the events and creates a label. I do not want to have
multiple labels for the same person (because they are
attending more than one event), so it must check all four
fields and print the name, address, etc. if attending one
or all of them.

If the Event field just contains the number of people who are
attending, how can you determine whether a particular person is
attending or not? What is the structure of the rest of this table, and
how is it related to other tables?