I have a button to allow user to click and see the last record. how is my sql statement like? Please help, Thanks.
if you have an identity(auto id) field, you can do <BR><BR>select top 1 * from table name order by id field desc
Select top 1 * from table order by field desc<BR><BR>Order it in reverse order on how you ordered it origionally, and select the first record (top 1)<BR><BR>-- Whol