Setting criteria for biggest value!!!

[Omar Anwar]

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.

[PEB]

Hi,
You have to type: Dmax("My_index_name","My_table","") in criteria clause in your update query