Duplicate results in my query

[Guest]

I created a query to show all entities signed up for certain events. Because
those entities can sign up multiple times for events, I get multiple entries.
Can I get access to show an entity only one time instead of multiple?

 

[Lynn Trapp]

You probably can by using the DISTINCT predicate in your query

SELECT DISTINCT Field1, Field2, Field3....
FROM YourTable;

Can you post the SQL of your query for us to look at?

 

[Guest]

If you are only returning columns from the referenced (one-side) table or any
columns returned from the referencing (many-side) table all contain the same
values for each row in the referenced table change the query to a SELECT
DISTINCT query, which you can do in SQL view or by setting the 'Unique
Values' property to 'Yes' in the query's properties sheet.

Ken Sheridan
Stafford, England