format report output to hours and minutes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI Guys,

I have a database which is running fine. I tried to add another report which
gives the output in hours and minutes from a query. I have used the code
below to format the oputput in several other reports (which all work fine),
how ever on a new form the code will not work. I tried a version n I found on
this site and I still get $error. Does anyone have any ideas where the
problem may lie??

Code used:
=([SumOfSumOfmin]\60) & " : " & Format$([SumOfSumOfmin] Mod 60,"00") above
is used in other reports and works fine..

=[SumOftot]\60 & Format([SumOftot] Mod 60,"\:00")

Thanks in advance

Andy
 
Andy Bt said:
I have a database which is running fine. I tried to add another report which
gives the output in hours and minutes from a query. I have used the code
below to format the oputput in several other reports (which all work fine),
how ever on a new form the code will not work. I tried a version n I found on
this site and I still get $error. Does anyone have any ideas where the
problem may lie??

Code used:
=([SumOfSumOfmin]\60) & " : " & Format$([SumOfSumOfmin] Mod 60,"00") above
is used in other reports and works fine..

=[SumOftot]\60 & Format([SumOftot] Mod 60,"\:00")
Click to expand...


The only things I can think of that micht cause #Error is:
the field is a Text field
and/or
the name of the text box is the same as the name
of the field.
 
Back
Top