Re: TOP 3 Most Recent Records

[cf]

sort by PK order by decending
then limit the output to 3 records


> How would you go about selecting the 3 newest records from an Access
> 2003 table where the PK is an autonumber and the table has no date/time
> field?
>
> Thanks.
>
> Mike
>
> 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: TOP 3 Most Recent Records

[Michael T. Tangorre]

Ubqtous,

 
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]

Re: TOP 3 Most Recent Records

[Ubqtous]

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]