SQL way of getting last recID

[James Kleinschmidt]

Is there a way to get the recID of the last added record for a table if 
it was added with the insert sql command?

Thanks,

Jim