Limiting decimal places

[Cran29]

I would like to limit the decimal places on a percentage. The working Expr is [ActiveHours]/[TotalHrsPaid]#100 What would I need to add to restrict it to display only 2 decimal points and to display the percentage sign.

[RuralGuy]

When you select the control and go to the Format tab of the property sheet, what is available in the Format property?

[Cran29]

When you select the control and go to the Format tab of the property sheet, what is available in the Format property?

I dont have a format property in the property sheet.

[RuralGuy]

What is the first property listed on the Format tab of the property sheet for this control?

[Cran29]

what is the first property listed on the format tab of the property sheet for this control?

caption is the first

[RuralGuy]

Now select the control that is displaying your calculation and what is the first property?

[Cran29]

The Query is run by a button on the form and the property sheet only dislpays information for the button. I cannot find any way in the property sheet to limitit the number of decimal places.

[Cran29]

%OfHrsPaidWorked: [ActiveHours]/[TotalHrsPaid]*100 This is the expr what do I need to add to display the % sign and limit the number of decimal places to two

[RuralGuy]

So you are simply displaying the raw query on the screen, not the results of the query on a form? Then how about using the Format() function?

[RuralGuy]

Each field in a query also has a Format property if you open the query in design view.

[Cran29]

Ok I have tried that and it gives the percentage 6307.69% rather than 63.07% the decimal place is wrong or the expr is wrong I have changed it to o decimal places and it comes up wrong ?

[RuralGuy]

As soon as you select the Percent format then you do not need to multiply by 100 any more.

[Cran29]

Its agood job one of has brains it works perfect now thanks

[RuralGuy]

Excellent! Are you ready to use the Thread tool and mark this thread as Solved?