What is the best way to check for the last of a record, example, 20 records of the date 01/01/09 and I want to do something after the last one?
Thanks Chad
TexasWebDevelopers -> RE: Last Of (4/29/2009 14:16:29)
I don't understand what you want to do. If you want to write the last record you could select the first item of a reversed select like: sql="SELECT TOP1 [field_name] FROM [table_name] WHERE [date_field] = [your date requirements] ORDER BY DESC;" If you want to write into the data then just do a sql insert and it will be the last entry.