List Box - Placing the most recent year at the top of the list

[CamL]

I have populated a list box using the following SQL in the row source:

SELECT DISTINCT Table1.Year FROM Table1;

The list box populates fine but sorts in ascending order which means I have the oldest year populating first. I would like to have the list populate in descending order so I have the most recent year at the top of the list.

I have tried to use Order By DESC but I get an error.

Any help on this is appreciated.

 

[pbaldy]

Using DESC would be the correct way. What was the SQL of your effort and what was the error?

 

[CamL]

Hi Paul,

Got it to work. I thought that I had tried this already.

SELECT DISTINCT Table.Year FROM Table ORDER BY Table.Year DESC;

Thanks for the quick response!