SELECT DISTINCT and SORT BY

[LB79]

Hello,

Im having a problem with SELECT DISTINCT and SORT BY. I want to remove dupliates from a ComboBox, but when I use SELECT DISTINCT it cause problems with the SORT BY.
Is there a fix for this?

Thanks

 

[DCrake]

Simple Software Solutions

Change your logic to "Group by" to remove duplicates from the rowsource.

Select Towns From Addresses Group By Towns Order by Towns

Coded for brevity only

 

[khawar]

SELECT DISTINCT [YourTable].[YourField]
FROM [YourTable]
ORDER BY [YourTable].[Your Field on which you want to order by];

 

[LB79]

Thanks for replying.
Do you mean in the query the combobox is tied to? If so, then I already tried that but it didnt work. If not in the query, then where?
Thanks again

 

[raskew]

Hi -

In your query, replace SORT BY with ORDER BY. If that doesn't solve the problem, please post your query SQL.

Bob

 

[LB79]

Thanks all for your help. Im not great with Access so sorry if im a bit vague in my replies...
My row source is
SELECT DISTINCT QRY.Type FROM QRY;
Now i just need it to sort (by another field of the query)

 

[khawar]

SELECT DISTINCT QRY.Type FROM QRY
ORDER BY qry.[Your Field on which you want to order by];

 

[LB79]

Ive tried to put the ORDER BY in but it says there is a conflict with SELECT DISTINCT and ORDER BY.

 

[khawar]

Its because you second field need to be in a query try this
first make a query in which sort by that second field on which you want to order by
then make a second query and get distinct value from that first query and dont add any order by clause

 

[khawar]

Doesnt seem to work it will sort on the selected field only