View Single Post
  #4  
Old November 23rd, 2006, 04:32 PM posted to microsoft.public.access.queries
Rick Brandt
external usenet poster
 
Posts: 4,354
Default 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