470,632 Members | 1,387 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,632 developers. It's quick & easy.

Setting criteria for biggest value!!!

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.
Jul 29 '06 #1
1 1553
1,418 Expert 1GB
You have to type: Dmax("My_index_name","My_table","") in criteria clause in your update query
Aug 29 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Cesar Ronchese | last post: by
4 posts views Thread by PJ6 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.