Show only most recent record

[JackieW]

I've got a *very* simple form, one field. I want a person to be able to go in and update a single number. (example: '10 are signed up of 100 entries' - with 10 being the form number) I only want the most recent number to show up, not the previous numbers. (example: I don't want yesterday's 9 to show up once I put in today's 10)

Right now I've got it set up in a typical Do, While, Wend loop, but of course that isn't going to work. Is there a simple, quick way to pull only the most recent number and display only that number from a database?

[umairraja52]

You can get latest records or updated latest records through time function, create time/date field in your database.

When you retrive data then use time with current time to retrive latest record.
Thanks

[JackieW]

Thanks! Worked like a charm.