Formatting the output of a query

jcaswell

Registered User.
Local time
Today, 22:07
Joined
Mar 16, 2002
Messages
18
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?
 
dblReturnHours = Round((dblReturnHours * 24),1)
 
Have you tried setting the format property for the query field?
 
Guys - thanks for this.

pbaldy - this worked.

DALeffler - yes I tried that first - right click on the column and define the number of decimal points etc. It seemed to make no difference. I felt that it ought to have worked, but no success.
 

Users who are viewing this thread

Back
Top Bottom