The sum of 2 Totals

[Manny74]

Hello All,

From Microsoft Teams, I was able to click on Totals to get total regular hours worked by my RNs, LPNs & MAs.

But how would I get a grand total?

Ideally, I want to be able to add, total REG + total OVT, to get 1735 in the TOTAL HOURS column....Unless there is another way of doing this?

ID	MONTH	ACCOUNT NUMBER	UNIT NAME	ROLE	REG	OVT	TOTAL HOURS (REG + OVT)
177	102021​	999999​	10 EAST	RN	1000	20
178	102021​	999999​	10 EAST	LPN	250	10
179	102021​	999999​	10 EAST	MA	450	5
180	102021​	999999​	10 EAST
TOTAL					1700	35

 

[Micron]

37 views and no answers - might be because we've no idea what we're looking at (table, query, form). Probably not a spreadsheet since this is posted in Access forum.
One solution might be to put the Reg and ovt hours in each row and do the sum on that column, same as the sum at the bottom of the other 2 columns. That would mean creating a calculated query field (if that's a query) such as TotalHrs: [REG]+[OVT]
I usually don't use sum feature of a query datasheet, but that might be another option but you'd need the values in the rows in the last column.

Display column totals in a datasheet using a Totals row - Microsoft Support

Add a Total row in Access to count or sum values in a column.

support.microsoft.com

 

[Manny74]

Thanks for the feedback Micron.
Yes this is a query from Microsoft Access.
I added a sum for REG column and got a total of 1700, then a sum for OVT and got 35....But would like the sum of 1700 and 35 (1735), but I can't figure out how to sum two columns....

 

[Micron]

One solution might be to put the Reg and ovt hours in each row and do the sum on that column, same as the sum at the bottom of the other 2 columns.

That could have been written more clearly. I meant to try putting the sum of reg and ovt in the last column in order to get a total at the bottom of the last column.
If that doesn't work, a form or report should be able to handle it. Queries are limited in what they can do in terms of displaying totals, and they are primarily meant to provide records to forms and reports, not records directly to users.