Calculation Issues

Calculate Student Award Donations in a Microsoft Access Query

Elise WilliamsElise Williams Nov 14, 2026 868 views

Question details

Calculate a Federation donation of 0.5% of each student award, list the results in Paper ID order, and find the grand total.

Product
Microsoft Access
Device & OS
not provided
Scenario
Use the 2F Student Papers table to calculate donations from student award amounts.
Observed behavior
The desired result is a list of calculated donations sorted by Paper ID and a separate grand total.
Before you start

Open the database in Microsoft Access and check the exact names of the Paper ID and award fields in the 2F Student Papers table. The examples below use [Award] as the award-field name; replace it if your field has a different name.

Solution 1Recommended

Create Access Queries for Individual Donations and the Grand Total

Use one query for the sorted student-level results and another to sum all donations.

1
Create a detail query

In Access, select Create > Query Design, add the 2F Student Papers table, and add the Paper ID and Award fields to the design grid.

2
Calculate each donation

In an empty Field cell, enter FederationDonation: [Award]*0.005. Replace [Award] with the actual award-field name if necessary.

3
Sort and run the query

In the Paper ID column, set the Sort row to Ascending. Select Run to display each award and its calculated donation, then save the query.

4
Create the grand-total query

Select Create > Query Design and switch to View > SQL View. Enter SELECT Sum([Award]*0.005) AS TotalDonation FROM [2F Student Papers];, adjusting the field or table name if necessary.

5
Run and save the total

Select Run to see the grand total, then save the query with a distinct name.

Create Access Queries for Individual Donations and the Grand Total
Check missing awards: Access ignores Null award values when calculating the sum. Review any missing awards if every student should contribute to the total.
Free Microsoft Office alternative

Review Award Donation Data in WPS Spreadsheets

WPS Office is a free, lightweight alternative for working with Office documents in a familiar interface. Export your Access results to an Excel workbook to review donation figures in WPS Spreadsheets; WPS does not create or run Access queries.

Review and sort exported student award and donation data in a spreadsheetOpen and edit Microsoft Excel XLSX files for a smooth transitionWork with a familiar spreadsheet interfaceUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why is the award multiplied by 0.005?

A rate of 0.5% equals 0.005 as a decimal. In the query design grid, [Award]*0.005 calculates that fraction of each award.

How do I change the order of the student results?

Open the detail query in Design View and set the Sort row under Paper ID to Ascending or Descending, then select Run.

What if Access asks me to enter an Award parameter?

Check the field name in the 2F Student Papers table. In Design View, replace [Award] in the calculated expression with the exact name of the award field.

Can I open the query results in WPS Spreadsheets?

Export the results from Access to an Excel workbook using External Data > Export > Excel, then open the XLSX file in WPS Spreadsheets. WPS does not run the Access query itself.