Queries; need assistance changing formats

[9944pdx]

I have a field in a query that looks like this:

decimal: CDbl([hours])*24

issue: instead of showing 9.80 it needs be shown as 9.8

I have right-clicked to format and it brings up the properties and the format is shown as fixed...what should it be?

Thanks for your help.

[ajetrumpet]

try

round(cdbl(hours)*24, 1)

[9944pdx]

Thanks for your help it worked but instead of returning 9.8 it showed 9.80.
Isn't there a format function i could add to such as: format ("#,##0.0").

I am not sure how to add it to what you already shown me.

Thanks again.

-pdx
Format (210.6, "#,##0.00")would return '210.60'
Format (210.6, "#,##0.00")would return '210.60'

[Rawb]

If you remove the "Fixed" format, it should do what you're looking for. If you get an error after removing "Fixed" you can try adding "General Number" in it's place.

Fixed numbers are always shown to a certain number of decimals no matter what the value is.

[9944pdx]

Everything worked.

See you next time.