Clash Royale CLAN TAG#URR8PPP

Microsoft Access - how change the label of the aggregate function “Totals” in its row

I've been trying to do some exercises from a book teaching on how to use MS Access (in my case 2016 version is utilized).

In one of the sections, an example is given on how to perform a quick calculation using the aggregate function by clicking the "Totals" buttons from the Record group in the HOME tab, all this on a query displayed in Datasheet View with some records present. The Query in question:

Now, in this query I (want to only) calculate/use the "Average" function over the "DonationValue" field values, which works.

The problem is, that the label at the beginning of the row says "Total", and I cannot seem to be able change it to say something else:

Even when I click over the "None" option from the falling options above, the label just remains saying "Total" (I don't know what to expect).

My question is, is there any way possible to change this label to say "Average" instead of "Total", so it is in a "logical conjunction" with the average aggregate function used further along the row? And how?

Workarounds are also welcome.

Cheers,
G.M.

1 Answer
1

Create a query using Union function like below:

SELECT PatronID, FirstName, LastName, DonationValue from Donation

Union

Select 'Average',null, null, Round(avg(DonationValue),2) from Donation


Note: When the query is attached to datasheet the form would be read-only

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.