How to get Latest or Nearest Date in SQL for Processing IN C#.net (Access 2003).

 just use the max function and subquery

com.CommandText = "select * from user_per where up_date=(select max(up_date) from user_per)";