Order by date in DESC

C

Chris B

I am trying to do an "Order by year(date) DESC" but 1999
always comes up first. This is done in a form. I have set
order by to "year([v_date]) DESC, V_Lable_ID DESC" for the
data of the form, and "ORDER BY year([V_Date])
Desc,DT_Video.V_Lable_ID Desc" in the select code within
the form. Any input would be helpful.

Chris B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top