How do you set up your SQL statement so that each day, the most recent entry (ie. by date) in a database table is displayed on the page?<BR>Thanks.
SELECT TOP 1 * FROM table ORDER BY theDate DESC<BR><BR>Use a list of particular fields in place of the * if you prefer.<BR><BR>
Thanks Bill! Oops, I was doing this:<BR>SELECT Top 1 FROM TABLE etc... :(
Yep, it insists on seeing some kind of list of fields.<BR><BR>You're not first to get bitten by that one.<BR><BR>