How do I list records in reverse order?

  • Thread starter Thread starter Shannon Yoder
  • Start date Start date
S

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
 
Shannon Yoder said:
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
Click to expand...

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
 
Back
Top