Show Top 20 Totals

[Guest]

Hi I am a beginner in Access just 1week since I learnt it

I have a Table with Name and TotalSalary there are 500 records in this table
I want to build a query which will show me Top 20 salaries
What formula should I type in the Criteria cell below TotalSalary in design
view

Thanks

 

[Jeff Boyce]

You won't use a "selection criterion".

First, sort the data by the salary, descending.

Instead, right-click in the open space above the grid in your query's design
view. Select Properties.

Set the Top property to 20. Run the query.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Guest]

Thanks
I am happy It worked fine

You won't use a "selection criterion".

First, sort the data by the salary, descending.

Instead, right-click in the open space above the grid in your query's design
view. Select Properties.

Set the Top property to 20. Run the query.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/