Not sure if access supports the TOP keyword, but this works in MSSQL Server:

SELECT Top 10 columnname, columnname...
FROM....

Probably works in Access too...

-Cameron

-----------------
Cameron Childress
Sumo Consulting Inc.
---
land:  858.509.3098
cell:  678.637.5072
aim:   cameroncf
email: [EMAIL PROTECTED]
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to