retrieving autonumber

[c_me_7]

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

[Nakor]

SELECT propertyID FROM tablename ORDER BY propertyID DESC LIMIT 1

[c_me_7]

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

[justsomeguy]

That SQL statement does work, so the problem is not the SQL. You can also do this:

SELECT MAX(propertyID) AS propertyID FROM tablename

[ray]

select @@identityIm using it and it seems to work fine

[aspnetguy]

That SQL statement does work, so the problem is not the SQL.  You can also do this:

SELECT MAX(propertyID) AS propertyID FROM tablename

<{POST_SNAPBACK}>

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

[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}>

[aspnetguy]

try this

SELECT TOP 1 propertyID FROM tablename ORDER BY propertyID DESC

[justsomeguy]

I might not be working considering that statement only works in MySql. What

Is MAX only available in MySQL? I thought most of the aggregate functions are part of the SQL standard.

[aspnetguy]

Is MAX only available in MySQL?  I thought most of the aggregate functions are part of the SQL standard.

<{POST_SNAPBACK}>

not sure, I was refering to LIMIT 1