RE: FN-FORUM sql for last entry of an access database

date posted 13th July 2001 15:50

This is a multi-part message in MIME format.

------=_NextPart_000_0018_01C10BB1.667BF080
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I'm assuming you want to get the last record entered in a table....

If you have an autonumber field sort descending on that and use TOP 1 to
return the last record entered.

Example.....
SELECT TOP 1 [MyTable].* FROM [MyTable] ORDER BY [MyTable].[Autonumber ID]
DESC;

Hope this is what you're after.

Regards

Karl Hitchcock

http://www.dzinezone.co.uk



-----Original Message-----
From: [EMAIL REMOVED]
[EMAIL REMOVED] Behalf Of Rob Garbutt
Sent: 13 July 2001 15:26
To: [EMAIL REMOVED]
Subject: FN-FORUM sql for last entry of an access database


does any one know the
sql for last entry of an access database



thanks in advance


Robin Garbutt
Portfolio Art & Design Ltd
Tel - +44 (0) 1204 383822
Fax - +44 (0) 1204 383866
Mob - +44 (0) 7811 185490
e-mail - [EMAIL REMOVED]

For further information please visit us at :-
www.portfoliodesign.net

The contents of this e-mail are confidential to the ordinary user of the
e-mail address to which it was addressed and may also be privileged. If
you
are not the addressee of this e-mail you may not copy, forward, disclose
or
otherwise use it or any part of it in any form whatsoever. If you have
received this e-mail in error please e-mail the sender.


------=_NextPart_000_0018_01C10BB1.667BF080
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








I'm=20
assuming you want to get the last record entered in a=20
table....
 
If you=20
have an autonumber field sort descending on that and use TOP 1 to =
return=20
the last record entered.
 
Example.....
SELECT=20
TOP 1 [MyTable].* FROM [MyTable] ORDER BY [MyTable].[Autonumber ID]=20
DESC;
 
Hope=20
this is what you're after.
 
Regards
 

Karl Hitchcock
http://www.dzinezone.co.uk=



-----Original Message-----From:=20
[EMAIL REMOVED]
[EMAIL REMOVED] Behalf Of Rob=20
GarbuttSent: 13 July 2001 15:26To:=20
[EMAIL REMOVED] FN-FORUM sql for last =
entry of=20
an access database
does any one know the
sql for last entry of an access database
 
thanks in advance
Robin GarbuttPortfolio Art =
& Design=20
LtdTel -  +44 (0) 1204 383822Fax - +44 (0) 1204 =
383866Mob -=20
+44 (0) 7811 185490e-mail -