Converting total minutes to hours in a report footer

[Lee B via AccessMonster.com]

I have the following expression in a text box in the report footer:
=Nz(Sum([Minutes]),0)+Nz(Sum([TimeWorkedS]),0). It works well providing
totals for my subgroups in the report and gives me the grand total in the
report footer.

I need to see the total minutes as hours and minutes.
Any help would be greatly appreciated.
Thanks
Lee

 

[Allen Browne]

If thest text box is named Text0, add another text box with Control Source
of:
=[Text0] \ 60 & Format([Text0] Mod 60, "\:00")

 

[Lee B via AccessMonster.com]

Thank you Allen.. that did the trick!!
Lee

If thest text box is named Text0, add another text box with Control Source
of:
=[Text0] \ 60 & Format([Text0] Mod 60, "\:00")

I have the following expression in a text box in the report footer:
=Nz(Sum([Minutes]),0)+Nz(Sum([TimeWorkedS]),0). It works well providing

[quoted text clipped - 5 lines]

Thanks
Lee