Calculate Student Award Donations in a Microsoft Access Query
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.
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.
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.
In Access, select Create > Query Design, add the 2F Student Papers table, and add the Paper ID and Award fields to the design grid.
In an empty Field cell, enter FederationDonation: [Award]*0.005. Replace [Award] with the actual award-field name if necessary.
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.
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.
Select Run to see the grand total, then save the query with a distinct name.

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.

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.




