Problem is sum hours, because when cross 24h start in zero
"Marco" wrote in message
...
Hi. thanks for your reply. I already have the column hours in long integer.
I have this total sum: 45,75399583.
If it was in excel, I format in costum as [h] it will work fine. I wanted
to do the same in access, in querie or form. in excel I can get 1098 but not
in access.
I fail to see how you can go from a sum of hours equaling 45,75399583 hours to
the number 1098.
Is the comma the decimal point character in your regional settings?
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
|