Thanks for replying. I did try to use the SQL you told me but it displays the whole records in the database with descending order. However, I only want to display the most recent record. In other words, I want to display one last record (recent update) only. Please help. I know I can do it in Access using Max to pick up the most recent record or Min for the the first record(oldest record). Thanks alot.