Duplicate results in my query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
 
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
 
Back
Top