order by question

I have the following SQL query

SQL = "SELECT * from nonconformance INNER JOIN nc_status ON nonconformance.status_id = nc_status.status_id INNER JOIN nc_major_category ON nc_major_category.major_category_id = nonconformance.major_category_id INNER JOIN nc_department ON nc_department.department_id = nonconformance.department_id AND car_only = '0'ORDER by nonconformance.nc_date"

The order by statement is set to sort my data in a datagrid by date. The issue I am having is it sorts by the lastest date first and the newest record or date is the last in the grid, so if i have 500 records the newest one is the last. How can I reverse the order by so that the newest date is first.

thanksORDER by nonconformance.nc_date DESC|||works great thanks