Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-06 : 14:48:59
|
Jeremy writes "I am entering information into an Access 2000 database of Equipment and unfortunately some records will be duplicated with some Serial Numbers being Unknown. When using the SQL statement, I need an efficient way of returning the Autonumber (AssetID) that was just entered. The current method loads all equipment with the model and S/N just entered ordered by AssetID and uses a .length property to find the number of records returned and then uses the last record returned. I'm guessing that there is a much easier way to do this...please let me know
Thanks,
Jeremy" |
|
|
|
|
|
What's that Autonumber?