<div>
post a copy of the db and explain, which records you want to see using a select top 100 query..
</div>


post a copy of the db and explain, which records you want to see using a select top 100 query..

<div>
<div class="content wysiwyg-content">
What is the SQL to select first 100 records?<br />
<br />
Currently I am using SELECT TOP 100 but this gives me records that have the same value in the descending field<br />
<br />
Thanks
</div>
</div>


What is the SQL to select first 100 records?

Currently I am using SELECT TOP 100 but this gives me records that have the same value in the descending field

Thanks

What is the SQL to select first 100 records?

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.