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]
