How to retrieve first X rows?

A

andraandjeff

Hi all,

I'm trying to figure out a way to retrieve only the first X rows from
my Access query. I know there are ways to do this in Oracle and in
other databases, but I can't seem to figure it out for Access. Any
ideas?

Thanks in advance,

Jeff
 
A

andraandjeff

No worries - I figured it out. Thanks anyway.

In case anybody needs to know, the syntax is SELECT TOP x [Field] FROM
[tableName]
 
Top