How do you select frist 1000 rows

[citychap26]

Hi Guys

I'm being lazy!!

In Sybase you can do the following to limit rows returned:

Set rowcount 1000

Then run any query and it will give you the first 1000 rows. How can you do this in Access ?

Cheers

SK

 

[citychap26]

Aha, figured it out, SELECT TOP 1000 x,y,z from table.