Summing in Access 2013 web app

[dslatten]

I have created a database that is hosted on our company sharepoint. The database contains subcontracts with resource information by geographic location and status. I have built queries and added them as reports to the web app but I need to figure out a way to sum totals on the queries. For example, one report lists all resources of a particular type by 4 different zones and 3 different status. I need to have the bottom row show the total resources. (See picture below). Any help would be greatly appreciated.

[June7]

Is this a crosstab query?

Is the Totals button available on ribbon for web db when query is in datasheet view?

Or are these report objects? Can you put textbox in report footer with expression: =Sum([Type II ALS Ground Ambulance])

[dslatten]

The queries and reports are built a bit different for web apps. I can create a query just a i could in the regular desktop version. So that's what i've done-with the totals button. But then, the report is built based off of that query with limited capabilities. There is really no flexibility with the actual report design so all calculations should be done in the query. So I suppose my question is how to sum each column in the query, if at all.

[June7]

Only other approach I can think of is to build an aggregate query and then a UNION query that merges the detailed dataset with the aggregate query. Apply sort order so the 'Totals' record is at bottom.

[dslatten]

Ok, I will research that and give it a try. Thanks.

[dslatten]

Nope, there isn't an option to build a union query with the Access App. Very limited. Was hoping there was some way to do it with macro or expressions?

[June7]

If there is no SQL view of query builder in web db, think you are out of luck.