Yet another thread on duplicate data problems.

[scottk]

I have a database with three tables. People, Events, Attendance. The tables are set up as follows:

People:
People ID - key
Name
Address

Events:
Event Id - key
Event Name
Date

Attendance:
People ID - key
Event ID - key

Of course the obvious fields link to each other.

What I would like to do is to pull up the names and addresses of people who attended specific events. The query is set up with the following fields:

Events:
Event Name
Criteria - "Dinner" Or "Open House"
(hidden)

People:
Name
Address

Now this works fine and all, but if John Smith attended both "Dinner" and "Open House" then his name appears twice in the resulting datasheet. Is there anyway I can set this up so that names only show once?

P.S. The Event field does not have to be shown in the resulting datasheet.

 

[Rich@ITTC]

Hi Scottk

In the Design View for your query open up the Properties window (right click on any grey area and select properties from the context sensitive menu).

Change "Unique Values" from No to Yes

HTH

Rich Gorvin

 

[scottk]

Wow, that was easy. Thanks!