Philip Horan (1/13/2009)
When in fact the last 5 orders appear in the middle?WO014563
WO014377
WO014378
WO014440
WO014268
How could you tell that these are the last 5 orders?
Will it be possible to return the last 5 orders with the absense of a date field?
Off course yes, but you have tell SQL that this is the column that identifies the order of the records.
If you meant that the order it was entered into the database then you have to know that rows in a table does not have a specific order.
--Ramesh