How to retrieve first X rows?

  • Thread starter Thread starter andraandjeff
  • Start date Start date
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
 
No worries - I figured it out. Thanks anyway.

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