G
Guest
Using Access2000. Have a need for a form (I can have it refresh every 5,10
secs or so) that works like a report, no editing or data entry just requerys
and requerys while it is open. The issue is that I need to time format in
hours (and yes greater than 24), minutes, seconds. Found a formula that
works great in a report but as I'm live monitoring the results and need to
refresh every 5,10 secs or so, a report won't work. The formula in the
report control is as follows
=[SumOfTimeField]\3600 & Format(([SumOfTimeField] Mod 3600)/86400,"nn:ss")
Same formula in the form control gives me an #ERROR# result. Changed the
formula to
=Sum([SumOfTimeField]\3600) & Format((Sum([SumOfTimeField] Mod
3600)/86400),"nn:ss")
And got the right format to showbut received the same results for all 4 of
the records on the form(it added them all up and that result then went to the
field for each of the records.)
The field [TimeField] is a number field measuring seconds from the beginning
of the day. My result set sums that field (with criteria that would give me
4 subsets of totals) with other calculations to determine length of time.
For example if I'm measureing logon time for 30 employees need to have
results in hours:minutes:seconds without any days.
Need to see the unique results for each record on the form. The underlying
query used for the form is showing the correct data and if I select the data
without formating I get the results just fine. Just need to format the
results to the hours:minutes:seconds.
HHHEEEEELLLLLLLPPPPPPP ( I believe in primal scream therapy )
secs or so) that works like a report, no editing or data entry just requerys
and requerys while it is open. The issue is that I need to time format in
hours (and yes greater than 24), minutes, seconds. Found a formula that
works great in a report but as I'm live monitoring the results and need to
refresh every 5,10 secs or so, a report won't work. The formula in the
report control is as follows
=[SumOfTimeField]\3600 & Format(([SumOfTimeField] Mod 3600)/86400,"nn:ss")
Same formula in the form control gives me an #ERROR# result. Changed the
formula to
=Sum([SumOfTimeField]\3600) & Format((Sum([SumOfTimeField] Mod
3600)/86400),"nn:ss")
And got the right format to showbut received the same results for all 4 of
the records on the form(it added them all up and that result then went to the
field for each of the records.)
The field [TimeField] is a number field measuring seconds from the beginning
of the day. My result set sums that field (with criteria that would give me
4 subsets of totals) with other calculations to determine length of time.
For example if I'm measureing logon time for 30 employees need to have
results in hours:minutes:seconds without any days.
Need to see the unique results for each record on the form. The underlying
query used for the form is showing the correct data and if I select the data
without formating I get the results just fine. Just need to format the
results to the hours:minutes:seconds.
HHHEEEEELLLLLLLPPPPPPP ( I believe in primal scream therapy )