hi iam having error with this select statement which works with sql server "select top 1 holidaypay from shiftpaid order by paidid desc". The error is the top, so if anyone could help. What I want to do is to select a column from a last row in a table. Thanx