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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
retrieving only 10 rows 2
Xbox Series X anomaly (sort of) 4
How can I Return Just One Row With a Query? 2
Retrieving data from a cell in the last row containing data in the worksheet 1
Retrieve data from Access database and fill data in form 0
Rows Retrieved In A Query 2
Format DATETIME to Date in query on linked table 4

Back
Top