P
peterde
Hi. I am in the process of modifying a established report to make it more
meaningful. In the report there are two quires that give an answer. I want to
add a third box adding these two together.
The first one is: =IIf([TotalCash] Is Null Or 0,"0:00",(Int([TotalCash]/60))
& ":" & (Format((([TotalCash])-((Int([TotalCash]/60))*60)),"00")))
The sencond one: =IIf([Time] Is Null Or 0,"0:00",(Int([Time]/60)) & ":" &
(Format((([Time])-((Int([Time]/60))*60)),"00")))
I would like to add those 2 results together, TIME and TOTALCASH to give a
third total (sum) to be named TOTALOT (in hh:mm). I am having trouble in
creating the query. Is this even possible? Thanks for any help that's offered.
meaningful. In the report there are two quires that give an answer. I want to
add a third box adding these two together.
The first one is: =IIf([TotalCash] Is Null Or 0,"0:00",(Int([TotalCash]/60))
& ":" & (Format((([TotalCash])-((Int([TotalCash]/60))*60)),"00")))
The sencond one: =IIf([Time] Is Null Or 0,"0:00",(Int([Time]/60)) & ":" &
(Format((([Time])-((Int([Time]/60))*60)),"00")))
I would like to add those 2 results together, TIME and TOTALCASH to give a
third total (sum) to be named TOTALOT (in hh:mm). I am having trouble in
creating the query. Is this even possible? Thanks for any help that's offered.