|
| |
|
|
ChrisChris
Posts: 4
From: USA
Status: offline
 |
How to find a record based on highest number - 4/15/2001 19:23:00
I am wondering if anyone can help me. i am interested inknowing how to search a database for a specific record based on the criteria that it is the most recent post (or the largest number in the index).I know how to make a search for specific values but not for how to bring back one record based on the "highest" number or "Latest" date. any help is most appreciated! Chris Chris
|
|
|
|
Steven Byrnes
Posts: 6
From: Sydney, NSW, Australia
Status: offline
|
RE: How to find a record based on highest number - 4/15/2001 20:02:00
SELECT Max(Fieldname) FROM Tablenameps but be careful if it's 'Datestamp' the field created by FP and you plan on updating it! ![]("http://www.frontpagewebmaster.com/ubb/smile.gif") See earlier post. -Steven
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
