many thanks.
:-)
_____
From: Ubqtous [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 15, 2003 9:52 AM
To: CF-Talk
Subject: Re: TOP 3 Most Recent Records
Michael,
On Saturday, November 15, 2003, 9:49:42 AM, you wrote:
MTT> How would you go about selecting the 3 newest records from an Access
2003
MTT> table where the PK is an autonumber and the table has no date/time
field?
This should work:
select top 3 * from table order by pk desc
~ Ubqtous ~
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
