<div>
you can get the top 100 &nbsp;using a query<br />
the order by will determine which 100 &nbsp;you want to get <br />
<br />
select top 100 *<br />
from TableX<br />
order by [fieldName]
</div>


you can get the top 100  using a query
the order by will determine which 100  you want to get

select top 100 *
from TableX
order by [fieldName]

<div>
(Will this stay in descending order all the time now?) <br />
may or may not, but that is irrelevant . You can always sort them using a query.
</div>


(Will this stay in descending order all the time now?)
may or may not, but that is irrelevant . You can always sort them using a query.

<div>
<div class="content wysiwyg-content">
Hello,<br />
I have created a table which is created from 2 append queries. I have indexed the table so field 'Total'<br />
is in descending order. Will this stay in descending order all the time now?<br />
<br />
My query is the table contains 22,000 entries and I only want the top 100 exported to Excel.<br />
Is it possible to loop through the table to only paste the first 100 entries to Excel and forget<br />
the rest?<br />
<br />
Thanks<br />
Ian
</div>
</div>


Hello,
I have created a table which is created from 2 append queries. I have indexed the table so field 'Total'
is in descending order. Will this stay in descending order all the time now?

My query is the table contains 22,000 entries and I only want the top 100 exported to Excel.
Is it possible to loop through the table to only paste the first 100 entries to Excel and forget
the rest?

Thanks
Ian

Export first 100 records from a table into Excel

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.