# >> Continuing Education >> Be Self Taught

How to Calculate Percentile With Two Groups in Access

Percentile rankings measure the position from the bottom of a value within a data set. Common uses for determining percentiles include finding a student's ranking within his class to evenly compare student rankings for students from varying class sizes. Access, Microsoft's database management system, allows users to create a table using SQL database language that combines two groups to show the percentile scores of each value in both groups. Learning how to calculate percentile with two groups in Access allows you to keep your values organized in multiple groups.

Instructions

- 1
  Run Access. Open the database that contains the two groups from which you wish to calculate percentile scores.
- 2
  Create a new table. Open the table editor to enter a definition using SQL.
- 3
  Type "select T.myField1 AND T.myField2, (select count(*) from myTable.myField1 AND myTable.myField2 <= T.myField1 and T.myField2)*100.0 / (select count(*) from myTable) from myTable as T group by myField1 AND myField2 order by myField1 AND myField2" without the quotation marks. Replace "myField1," "myField2" and "myTable" with the name of the table and fields that contain the data you want to analyze.
- 4
  Save the definition in the table editor. View the table to see the calculated percentiles from the two groups.

How to Use a Google API With AS3

How to Bolster Your Vocabulary

Be Self Taught