I want to allow a web user to determine the number of rows to retrieve from a database beginning with most recent record and go in descending order. Here is what I am trying (but it is not working):
sql = "SELECT LAST " & iNumToShow & " Bib, PartName, Age, Gender, City, St, Race FROM AnnouncerReads WHERE EventID = " & lEventID
sql = sql & " ORDER By AnnouncerReadsID DESC"
Any help would be much appreciated.