I am using the below Querry and it works great as is, however I need it too sort by one more field and I just can't seem to get it set-up righ can one of you please take a look and help me out.
Adodc1.RecordSource = "SELECT * FROM Schedule WHERE Date BETWEEN #" & StartDate & "# and #" & EndDate & "# ORDER BY Date And ORDER BY WONum"
The section "And ORDER BY WONum" is where I get the error.
Thanks "The beauty of the second amendment is, that it will not be needed until they try to take it." - Thomas Jefferson
WebMaster:
Adodc1.RecordSource = "SELECT * FROM Schedule WHERE Date BETWEEN #" & StartDate & "# and #" & EndDate & "# ORDER BY Date And ORDER BY WONum"
The section "And ORDER BY WONum" is where I get the error.
Thanks "The beauty of the second amendment is, that it will not be needed until they try to take it." - Thomas Jefferson
WebMaster: