Getting the Top 100

[sabbur]

I'm pulling a list of customers from our Linux database using ODBC. Using the AR Balance column what criteria do I insert to get the top 100 accounts?

Thank you,
Debbie

[alansidman]

With your query open in design view. Highlight the field (column) you wish to get the 100 top account. In the drop down next to the Sigma on the tool bar, select 100. Run your query. To see what it looks like in SQL, change the view from datasheet or design to SQL in the upper left corner.