Display last record only?

[kbrooks]

This should be simple, but the solution is escaping me.

I have a very simple database with 1 table. Fields are ID (autonumber), MDate, Time, Message. We're updating it via a web form, and also want to display the results via a webpage. It's simply for IS staff to enter a system status message, to notify the entire facility when there are problems.

I want a query that will always display the most recent entry only. I originally thought I'd base it on the date...but since it may be weeks between entries, I don't think that will work.

Based on another post I found during a search, I tried a query and in the Properties set Top Values to 1. But that gave me the FIRST entry, not the most recent one.

Is this possible?

 

[boblarson]

This should be simple, but the solution is escaping me.

I have a very simple database with 1 table. Fields are ID (autonumber), MDate, Time, Message. We're updating it via a web form, and also want to display the results via a webpage. It's simply for IS staff to enter a system status message, to notify the entire facility when there are problems.

I want a query that will always display the most recent entry only. I originally thought I'd base it on the date...but since it may be weeks between entries, I don't think that will work.

Based on another post I found during a search, I tried a query and in the Properties set Top Values to 1. But that gave me the FIRST entry, not the most recent one.


Is this possible?

Use the query, but set the sort in DESCENDING order on the date and then use the Top Value of 1.

 

[kbrooks]

Well don't I feel like a moron.....I KNEW it was something simple I was missing. Thanks for your quick response!