This might be an easy one (or it might not).

[scottk]

I have three tables in my database.

Personal Information
--------------------
Personal ID
Name
Address
Phone

Attendance
----------
Personal ID
Event ID

Events
------
Event ID
Event Name
Date

The obvious fields relate to each other. What I need to do is query for people who attend one specific event and attended a second specific event (The same person attends both events). However, everthing I have tried has resulted in no records being found on in everyone who attended either event being found. How can I set this up propperly?

 

[directormac]

The way I do this takes more than one query, but it works. Run a select query that finds all the people who went to Event A. Run another that finds everyone who went to Event B. Run a third query that combines those two lists. Run a fourth that finds dupes in the PersonID field.. Anybody who is duped went to both events.

 

[SteveV]

Set up a query and specify = Event ID in one criteria and = Event Name in another field of the search. If you set up the Event Name to be the one event and the Event ID to be the secound I believe this will work. Give it a shot, if it doesn't work email me your DB and I can try it.