Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 order by

Author  Topic 

mana
Posting Yak Master

102 Posts

Posted - 2014-08-18 : 08:46:09
Posted - 08/18/2014 : 08:34:28
--------------------------------------------------------------------------------




Hello

i Hva ethis error message in access when i want to sort a field. how can i solve this problem?

a column was mehrmls specified in the order by list.
columns in the order by list must be unique

I have a grid in access and when i want to sort a field as A to Z or Zto A i have this problem.Thank you for your help

Mar
Starting Member

47 Posts

Posted - 2014-08-19 : 08:59:11
Post your code.
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2014-08-19 : 09:19:54
check your ORDER BY
the same column name appear in your order by clause twice


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -