467,923 Members | 1,436 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,923 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
  • viewed: 1511
Share:
1 Reply
PEB
Expert 1GB
PEB
Hi,
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.