Pull most recent record

[JeffreyDavid]

I have a field in a table that updates from a web site automatically. So what is the most recent record now, next week the most recent record will be different. I need to be able to pull the most recent record, at any point in time, from that table and display on a form.

Does anyone know?

 

[Pat Hartman]

If your table has an autonumber, you can use the Max() function to return the record with the hightst autonumber. Less reliable is if you have a date/time field that is populated with the Now() function when a record is inserted, you can use the Max() function on that.