Re: How to retrieve id of last inserted record in Access without using @@identity?
- From: "J.S." <jss@xxxxxxxxxx>
- Date: Wed, 24 Aug 2005 08:21:44 -0700
Tina,
I am using Increment and not Random.
Thanks,
J.S.
--
"tina" <nospam@xxxxxxxxxxx> wrote in message
news:ZeCNe.639606$cg1.219154@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> With Max you will always
>> get the last record entered because the last record entered always has
>> the
>> highest ID if you are using autonumbers.
>
> that should hold true if the Autonumber field's NewValues property is set
> to
> Increment, but not necessarily if the NewValues property is set to Random.
.
- References:
- How to retrieve id of last inserted record in Access without using @@identity?
- From: J.S.
- Re: How to retrieve id of last inserted record in Access without using @@identity?
- From: Eric D via AccessMonster.com
- Re: How to retrieve id of last inserted record in Access without using @@identity?
- From: PC Data***
- Re: How to retrieve id of last inserted record in Access without using @@identity?
- From: tina
- How to retrieve id of last inserted record in Access without using @@identity?
- Prev by Date: Re: How to retrieve id of last inserted record in Access without using @@identity?
- Next by Date: Union Query Returns.
- Previous by thread: Re: How to retrieve id of last inserted record in Access without using @@identity?
- Next by thread: Re: How to retrieve id of last inserted record in Access without using @@identity?
- Index(es):
