A
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?
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?