In your SQL query you can add an ORDER BY clause. After the field you can
use DESC for descending order, ASC for ascending order. For example,
SELECT * FROM Table ORDER BY LastName DESC
--
David Berry - MCP
Microsoft MVP - FrontPage
FrontPage Support:
http://www.net-sites.com/sitebuilder/
-----------------------------------
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
-----------------------------------
"Rob" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Is there a way to have the results show up last to first instead of first
to
> last?
>
> Is there a way to have the results show up in alphabetical order?
>
> Thanks
>
>