Is there away to retive the to record only from a database. <BR>e.g the last one added?
if you're using access you can grab the last record added by using rst.MoveLast and then whatever you want to do with it. Hope thats what u meant
any one know who to do this in SQL???
SELECT TOP 1 fieldname<BR>FROM Table<BR>ORDER BY Desc<BR><BR>By default, it should give ya the last inserted record.
do you have a field of record creation date in your table? If then<BR><BR>select * from table where creation_date = (select max(creation_date) from table)
SELECT TOP 1 fieldname<BR>FROM Table<BR>ORDER BY fieldname Desc<BR><BR>
LOL! You are correct sir...<BR><BR>it's early in the morning here (9AM)... my mind hasn't woke up all the way yet.<BR><BR>Good catch!