Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-06 : 11:18:58
|
David writes "Hi,
This is probably very easy for you guys, but I am new to SQL and have a very simple problem. I am developing a Fault Logging Intranet system for a company using ASP and Access 2000.
To show the latest faults (which are held in a database called tblReports) I wish to show the latest fault at the top of the page rather than the bottom (because my ORDER BY is putting the largest number last).
So, instead of having this;
strSQL(SELECT FID FROM tblReports ORDER BY FID)
and getting this (output);
FID = 1,2,3,4,5,6,7
I want the output to display it the other way;
FID = 7,6,5,4,3,2,1
See? Easy eh? Could you tell me! Thank you in advance!" |
|
|
|
|
|
|
|
ORDER BY -- but the other way up!