I am calling a module from within a query to establish working hours etc. and am getting the right answer, but to far to may decimal points. The code fragments are as follows:
Module:
'convert days to hours
dblReturnHours = (dblReturnHours * 24)
Query:
fncReturnHours([Call records.Date Received],[Call Records.Date Decision],#12/30/1899 8:30:0#,#12/30/1899 17:30:0#) AS TotalHours
~ note the #12/30/1899 8:30:0#,#12/30/1899 17:30:0# merely sets out the working hours
Somewhere in these two fragments I feel that I should be able to define that I want the output to one decimal point, but I cannot work out how.
Can anyone help?
Module:
'convert days to hours
dblReturnHours = (dblReturnHours * 24)
Query:
fncReturnHours([Call records.Date Received],[Call Records.Date Decision],#12/30/1899 8:30:0#,#12/30/1899 17:30:0#) AS TotalHours
~ note the #12/30/1899 8:30:0#,#12/30/1899 17:30:0# merely sets out the working hours
Somewhere in these two fragments I feel that I should be able to define that I want the output to one decimal point, but I cannot work out how.
Can anyone help?