Logo
programming4us
programming4us
programming4us
programming4us
Home
programming4us
XP
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Windows Phone
 
programming4us
Windows 7

Microsoft Access 2010 : Finding the Largest and Smallest Values in a Field by Using a Query

7/16/2012 3:56:34 PM
When you create a query, you can have Access display a set number of the highest and lowest values in the query’s results. You can also have Access display rows that contain the top or bottom values by asking Access to display a certain percentage of rows in the query’s results. For example, if you reward the top 10 percent of your sales staff, you can create a query that sorts the query results according to the values in the Total Sales field and displays the best values. When you filter a query’s results by a percentage, you don’t need to know the exact number of records in your table. In other words, if your sales staff is made up of 40 employees, creating a query that displays the top 10 percent of sales totals will return the top 4 representatives.

1. Find the Largest Values in a Field

  1. Open a query in Design view.

  2. Click the Sort cell of the field in which you want to find the top values.

  3. Click the down arrow that appears.

  4. Click Descending.

  5. If necessary, click the Design tab.

  6. Using the Top Values field control, perform any of these tasks:

    • Click the control’s down arrow and select a default value to specify the number of values or the percentage of values to display.

    • Type a number indicating the number of values you want displayed in the query results.

    • Type a percentage indicating the portion of the table’s rows you want displayed in the query results.

  7. Click Run.

2. Find the Smallest Values in a Field

  1. Open a query in Design view.

  2. Click the Sort cell of the field in which you want to find the top values.

  3. Click the down arrow that appears.

  4. Click Ascending.

  5. If necessary, click the Design tab.

  6. Using the Top Values field control, perform any of these tasks:

    • Click the control’s down arrow and select a default value to specify the number of values or the percentage of values to display.

    • Type a number indicating the number of values you want displayed in the query results.

    • Type a percentage indicating the portion of the table’s rows you want displayed in the query results.

  7. Click Run.


Note:

To have your query display all its results, return to Design view, click the Design tab, click the Top Values field’s down arrow, and then click All.

Other -----------------
- Microsoft Access 2010 : Creating Queries - Creating a Crosstab Query
- Microsoft Access 2010 : Creating Queries - Writing Query Results to a New Table, Creating an Update Query
- Microsoft Excel 2010 : Defining Multiple Alternative Data Sets
- Microsoft Excel 2010 : Defining an Alternative Data Set
- Tools for Troubleshooting (part 9) - TCPView, Telnet Client
- Tools for Troubleshooting (part 8) - Route & Task Manager
- Tools for Troubleshooting (part 7) - Resource Monitor, Ping & PortQry
- Tools for Troubleshooting (part 6) - Performance Monitor & Data Collector Sets
- Tools for Troubleshooting (part 5) - PathPing
- Tools for Troubleshooting (part 4) - Nslookup
 
 
Top 10 video Game
-   Minecraft Mods - MAD PACK #10 'NETHER DOOM!' with Vikkstar & Pete (Minecraft Mod - Mad Pack 2)
-   Minecraft Mods - MAD PACK #9 'KING SLIME!' with Vikkstar & Pete (Minecraft Mod - Mad Pack 2)
-   Minecraft Mods - MAD PACK #2 'LAVA LOBBERS!' with Vikkstar & Pete (Minecraft Mod - Mad Pack 2)
-   Minecraft Mods - MAD PACK #3 'OBSIDIAN LONGSWORD!' with Vikkstar & Pete (Minecraft Mod - Mad Pack 2)
-   Total War: Warhammer [PC] Demigryph Trailer
-   Minecraft | MINIONS MOVIE MOD! (Despicable Me, Minions Movie)
-   Minecraft | Crazy Craft 3.0 - Ep 3! "TITANS ATTACK"
-   Minecraft | Crazy Craft 3.0 - Ep 2! "THIEVING FROM THE CRAZIES"
-   Minecraft | MORPH HIDE AND SEEK - Minions Despicable Me Mod
-   Minecraft | Dream Craft - Star Wars Modded Survival Ep 92 "IS JOE DEAD?!"
-   Minecraft | Dream Craft - Star Wars Modded Survival Ep 93 "JEDI STRIKE BACK"
-   Minecraft | Dream Craft - Star Wars Modded Survival Ep 94 "TATOOINE PLANET DESTRUCTION"
-   Minecraft | Dream Craft - Star Wars Modded Survival Ep 95 "TATOOINE CAPTIVES"
-   Hitman [PS4/XOne/PC] Alpha Gameplay Trailer
-   Satellite Reign [PC] Release Date Trailer
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 windows Phone 7 windows Phone 8
programming4us programming4us
 
Popular keywords
HOW TO Swimlane in Visio Visio sort key Pen and Touch Creating groups in Windows Server Raid in Windows Server Exchange 2010 maintenance Exchange server mail enabled groups Debugging Tools Collaborating
programming4us programming4us
PS4 game trailer XBox One game trailer
WiiU game trailer 3ds game trailer
Trailer game
 
programming4us
Natural Miscarriage
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Game Trailer