c_me_7

Thanks for your repliesApologies, i failed to mention that I am using Microsoft Access.Regards

I might not be working considering that statement only works in MySql. What database are you using???

<{POST_SNAPBACK}>

SELECT propertyID FROM tablename ORDER BY propertyID DESC LIMIT 1

<{POST_SNAPBACK}>

it dont work man :)If you dont mind can you send me your email address and i wil winzip you the filesthanks for you reply

no reason all server scripting languages have similar capabilitys. choose one that you understand easily

<{POST_SNAPBACK}>

thanks for you replyyeh but for my project i have to justify WHY i chose ASPand WHY i chose it as opose to other languages

Why should i use ASP?Why should I use it as oppose to other languages such as PHP or JSP?Regards

HiI need to retrieve the autonumber of the last record i added to my Property table.The autonumber attribute is called propertyIDregards