SQL and ORDER BY *SOLVED*

There is probably a simple answer to this but I can't work it out. I've got a query that I need to sort the Dates found by ASC order but I keep getting errors. The query ran perfect until I tried to add the ORDER BY part. Can someone help me out.

Thanks.

Code:

---

sSQL = "Select * from Party WHERE [Date Of Party] BETWEEN " & CLng(DTPicker1.Value) & " AND " & CLng(DTPicker2.Value) ORDER BY [Date Of Party]

---

How about

sSQL = "Select * from Party WHERE [Date Of Party] BETWEEN " & CLng(DTPicker1.Value) & " AND " & CLng(DTPicker2.Value) & " ORDER BY [Date Of Party]"

Thanks MartinLiss, i knew it would be something very simple :D