Re: Show Top 20 Totals

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
http://mvp.support.microsoft.com/

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


"claude jerry" <claudejerry@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0EC643C0-F2A2-4912-8F3D-03E0B9229630@xxxxxxxxxxxxxxxx
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

.

Relevant Pages

  • Re: Relationship question
    ... the design as a separate identity. ... CONTACTS_ID (Primary Key - Autonumber) ... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: What happened to Paul Miller?
    ... > As far as I know, we don't have an agreement yet. ... >> have to risk any money. ... when you won't provide even the minimum to design the ... > try to work together to define the criterion, ...
    (sci.physics.relativity)
  • Re: What happened to Paul Miller?
    ... > As far as I know, we don't have an agreement yet. ... >> have to risk any money. ... when you won't provide even the minimum to design the ... > try to work together to define the criterion, ...
    (sci.physics.relativity)
  • Re: What happened to Paul Miller?
    ... If I had no resources, ... when you won't provide even the minimum to design the ... said from the start, I'm not a physicist, but my friend is. ... Like with a pass/fail criterion. ...
    (sci.physics.relativity)
  • Re: Relationship question
    ... The thing that bothers me about the design is that a person cannot be ... Microsoft Office/Access MVP ... Departement_ID (Data type: AutoNumber, Primary Key) ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.tablesdbdesign)