Weird Error Message

[Anthony]

I keep getting this error:

ORDER BY clause ([ServiceYear]) conflicts with DISTINCT.


when this line tries to execute:

cboYear.RowSource = "SELECT DISTINCT [Service Year] FROM
ServiceDetails WHERE [ServiceCode] = 'ABC' ORDER BY [ServiceYear] DESC "


What am I doing wrong?

 

[Stefan Hoffmann]

hi Anthony,

I keep getting this error:
ORDER BY clause ([ServiceYear]) conflicts with DISTINCT.
when this line tries to execute:
cboYear.RowSource = "SELECT DISTINCT [Service Year] FROM
ServiceDetails WHERE [ServiceCode] = 'ABC' ORDER BY [ServiceYear] DESC "
What am I doing wrong?

Typo in the select list there is a space in the field name.


mfG
--> stefan <--

 

[Anthony]

No, that's not the problem because the field name has square brackets
([Field Name]) around it.

This, however, would be invalid:

(Field Name)

But this, would not:

([Field Name])

hi Anthony,

I keep getting this error:
ORDER BY clause ([ServiceYear]) conflicts with DISTINCT.
when this line tries to execute:
cboYear.RowSource = "SELECT DISTINCT [Service Year] FROM
ServiceDetails WHERE [ServiceCode] = 'ABC' ORDER BY [ServiceYear] DESC "
What am I doing wrong?

Typo in the select list there is a space in the field name.


mfG
--> stefan <--

 

[Anthony]

oh, never mind - you are correct.

hi Anthony,

I keep getting this error:
ORDER BY clause ([ServiceYear]) conflicts with DISTINCT.
when this line tries to execute:
cboYear.RowSource = "SELECT DISTINCT [Service Year] FROM
ServiceDetails WHERE [ServiceCode] = 'ABC' ORDER BY [ServiceYear] DESC "
What am I doing wrong?

Typo in the select list there is a space in the field name.


mfG
--> stefan <--

 

[Anthony]

thanks, Klatuu, that is correct

It appears to be a typo. You have it as [ServiceYear] in one place and
[Service Year] in another.
--
Dave Hargis, Microsoft Access MVP

I keep getting this error:

ORDER BY clause ([ServiceYear]) conflicts with DISTINCT.


when this line tries to execute:

cboYear.RowSource = "SELECT DISTINCT [Service Year] FROM
ServiceDetails WHERE [ServiceCode] = 'ABC' ORDER BY [ServiceYear] DESC "


What am I doing wrong?