Formatting formulas

[katrinanyc926]

I finally figured out how to convert the HH:MM format to a decimal number in an Access query. Now, I cannot get the number to only show 2 decimal places. I am using the property sheet, but it still won't show up how i want it to.

Any ideas?

[NTC]

in your display object (form or report) - that text box also have properties you can use for control. Make its property as Fixed (number type), 2 decimal. and it should work.

[katrinanyc926]

It worked! Thank you!!!