Limiting Duplicates

[Zerdan]

I have a query that is display results in a form and there are duplicate entries for a couple items for some reason that are appearing in the results. The table that I'm querying I do not have write privileges so I can't just delete the duplicates, so I will need to filter them out in the results.

I have read about SELECT DISTINCT but have not been able to get it to work. I'm using Access 2003. Any suggestions on ways to do this? Thank you.

[orange]

What can't you get working with Select Distinct?
Show us the code.

[Zerdan]

I have multiple tables joined in the query so my SELECT statement is quite long. It errors when I add this though:

SELECT DISTINCT dbo_MasterData.OrderNumber FROM

The error it gives is Syntax error (missing operator) in query expression 'DISTINCT dbo_MasterData.OrderNumber'.

The code looks like this right now and it works, but there are duplicate order numbers that I'm trying to filter:

SELECT dbo_MasterCustomer.CustomerCity, dbo_MasterCustomer.CustomerFirstName, dbo_MasterCustomer.CustomerLastName, dbo_MasterData.OrderNumber FROM

[orange]

Show all the code for the query, not just part.

[Zerdan]

Figured it out. Just needed to move the distinct to the very beginning for some reason.