Technics
Member
- Local time
- Today, 09:30
- Joined
- Aug 9, 2025
- Messages
- 53
Hi all,
Wanted to see if I could get some help with this. As you can see in photo I have date/time totals which provide footer totals. I am using basic math in the form query to get these footer totals. Expressions listed. This is all working correctly giving me all correct totals. The problem, hope photos illustrate, is I get no totals until I close and reopen the form. I am trying to figure out if there is a way for the footer totals to show without having to close and open the form.
Query math:
TotalMinutes: DateDiff('n',[StartTime],[EndTime])
HoursWorked: Round([TotalMinutes]/60,2)
WholeHoursWorked: Int([HoursWorked])
MinutesLeft: [TotalMinutes]-([WholeHoursWorked]*60)
Duration: [WholeHoursWorked] & ":" & Format([MinutesLeft],"00")
Wanted to see if I could get some help with this. As you can see in photo I have date/time totals which provide footer totals. I am using basic math in the form query to get these footer totals. Expressions listed. This is all working correctly giving me all correct totals. The problem, hope photos illustrate, is I get no totals until I close and reopen the form. I am trying to figure out if there is a way for the footer totals to show without having to close and open the form.
Query math:
TotalMinutes: DateDiff('n',[StartTime],[EndTime])
HoursWorked: Round([TotalMinutes]/60,2)
WholeHoursWorked: Int([HoursWorked])
MinutesLeft: [TotalMinutes]-([WholeHoursWorked]*60)
Duration: [WholeHoursWorked] & ":" & Format([MinutesLeft],"00")
Last edited: