How do I list records in reverse order?

[Shannon Yoder]

Could someone tell me how you use ASP script on a web page to list
records from an Access database in reverse order?

Thanks in advance,
Shannon

 

[Jon]

Could someone tell me how you use ASP script on a web page to list
records from an Access database in reverse order?

Thanks in advance,
Shannon

Shannon

When you connect to a database using ASP, you will often use a SQL
string as the basis for your recordset, something like:

strSQL="SELECT Field1, Field2 FROM tblName;"
Set rs=objConn.Execute(strSQL)

You therefore just need to amend the SQL statement to have an ORDER BY
clause in, something like:

strSQL="SELECT Field1, Field2 FROM tblName ORDER BY Field2 DESC;"
Set rs=objConn.Execute(strSQL)

Jon

Access tips & tricks - http://www.applecore99.com
Microsoft Access webring -
http://a.webring.com/hub?ring=microsoftaccess