Hi, i m stuck again. in my update query, i want to update the time and date of the latest record entered only. For this i have to select the latest recod first. they are indexed so selecting the record with biggest index will solve the problem. plz tell me how to select biggest index in the record using the criteria statement. Any help will be appriciated.
|