format report output to hours and minutes

[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

 

[Marshall Barton]

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")

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.