Dear All
I am using ASP for getting data from database and display now i want to sort my data while i am displaying it on webpage by date the existing query i am using is
strSQLAcc = "SELECT Accounts.* FROM Accounts WHERE Accounts.RegNo = " & rsSociety.Fields("RegNo").Value
any one can help me to rewrite this query according to my new requirement
thank you


Saifi

"SELECT Accounts.* FROM Accounts WHERE Accounts.datecol = '" & format(rsSociety.Fields("datecol").Value,"dd-MMM-yyyy") & "'"

confirm aruguments of format function, I am not sure about it.

urt

Help yourself by helping someone.

I think I made a mistake

"SELECT Accounts.* FROM Accounts WHERE Accounts.RegNo = " & rsSociety.Fields("RegNo").Value & " order by accounts.datecol"

urt

Help yourself by helping someone.

Since you say:

;;;I am using ASP for getting data from database and display

I assume your query is working ok? Not sure why urtrivedi altered it..... Anyhow to order an existing working query you simply append:

" ...... ORDER BY [yourDateFieldName];"

NOTE - Its a good practice to place trailing semi colons at the end of any query. I assume 'yourDateFieldName' is a date data type? It needs to be to get what you want. Remember things are ordered ascending by default. To reverse this you need to place DESC at the end of the query

Wind is your friend
Matt
www.elitemarquees.com.au