Thanks for the advice guys.
I am developing the query to be the record source for a report.
Thanks for pointing out that the Format function returns a text value -- I should have known that. I then tried the FormatNumber function in the query grid but it also yields text not numbers:
Code:
TotalHours: FormatNumber((Nz([SumOfdhHours],0)+Nz([SumOfdhMinutes]/60,0)),1,-1,-1,-1)
Here is what I have settled on: Setting the format of TotalHours to General Number in properties and using this code in the query grid yields a number field with one digit to the right of the decimal point, which is what I was working toward:
Code:
TotalHours: Round(Nz([SumOfdhHours],0)+Nz([SumOfdhMinutes]/60,0),1)
Appreciate the help.