SQL String fejl (simpel)

Hej, jeg ved ikke hvordan jeg får min sql string til at kun at hente de ID'er hvor Dato IKKE er tom, altså ( dato <> '' ) ?? men nej, siger den :)


min kode:

<%
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="&Server.MapPath("../mdb/_access.mdb")
SQLstringK="SELECT * FROM bestillinger ORDER by afsendt WHERE ( Dato <> '' )"
SET RS=Connection.Execute(SQLstringK)

while not RS.EOF
%>
    <tr>
        <td style="padding: 4px; border-bottom-style:solid; border-bottom-width:1px" width="20%"><%=rs("bestilt")%></td>
        <td style="padding: 4px; border-bottom-style:solid; border-bottom-width:1px" width="25%"><%=rs("fornavn")%>&nbsp;<%=rs("efternavn")%></font></td>
        <td style="padding: 4px; border-bottom-style:solid; border-bottom-width:1px" width="25%"><%=rs("produktnavn")%></td>
        <td style="padding: 4px; border-bottom-style:solid; border-bottom-width:1px" width="10%"><%=rs("vareID")%></td>
        <td style="padding: 4px; border-bottom-style:solid; border-bottom-width:1px" width="10%"><%=rs("antal")%></td>
        <td style="padding: 4px; border-bottom-style:solid; border-bottom-width:1px" width="15%"><p align="right"><a href="_bestillinger.asp?id=<%=rs("id")%>">
        <img border="0" src="gfx/see.gif" width="21" height="21"></a></td>
    </tr>
<%
RS.MoveNext
wend

RS.close
set RS =nothing
connection.close
set connection = nothing
%>


fejl

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'afsendt WHERE ( Dato <> '' )'.

/admin/_bestillinger.asp, line 111

linie 111:

SQLstringK="SELECT * FROM bestillinger ORDER by afsendt WHERE ( Dato <> '' )"

MVH crasher