Ordering the Results page

[Mark M S]

I am using Frontpage 2003 and create a listing of grants with the database
results wizard. As I add new entries to the asp results page it orders the
entries with the oldest to the newest requiring the viewer to start at the
oldest at the top and scroll to the newest at the bottom of the screen.

How can I reverse the order (see:
http://www.aapca1.org/aapca1/grantresult.asp as an example) so that the
newest entries are at the top?
*************************************************
Mark M Simonian MD FAAP
Medical Director, ChildNet Medical Assoc.
681 Medical Center Drive West #106
Clovis, CA 93611
(559) 325-6850
www.markmsimonian.medem.com
****************************************
Alert: This email and any files transmitted with it
are intended solely for the use of the individual or
entity to whom they are addressed and may contain
confidential, patient health or other legally
privileged information. If you have received this
email in error please notify the sender by email,
delete and destroy this message and its attachments.
Any unauthorized review, use, disclosure,
or distribution is prohibited.

 

[MD Websunlimited]

Hi Mark,

Does the table contain a date / time field ? If so, you can have the SQL sort on that field.

If it does not have the field you can add it and make it so that it populates with the current date and time automatically.

--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
Wish you could calculate form field totals? Well, you can with Form Caculator
http://www.websunlimited.com/order/Product/FormCalc/formcalc.htm
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible