4.1542589% but I only want to see the 4.1%

[TJVFree]

I have a query that calculates a percentage.
After it funs it looks like this:

4.1542589% but I only want to see the 4.1%.

Is there a easy way to change to this in the properties tab?

The results look like this after running the query.

0to5Rank
2.00833333333333 - Would like 2.1
3.03055555555556 - Would like 3.0
3.74444444444444 - Would like 3.7
1.47222222222222 - Would like 1.4
2.88611111111111 -- Would like 2.9

 

[MajP]

in the query builder right click on the field and edit the format property.

 

[dhookom]

CoreyVI,
What is the logic behind your rounding? Typically values >5 are rounded up and <5 are rounded down. You have 1.472 and 4.154 both rounding down and others seem to round up that shouldn't such as 2.008 to 2.1.

What's up?

Duane
Hook'D on Access
MS Access MVP

 

[TJVFree]

I apologies for that confusion. Your right, I just want to round up or down by 5

 

[dhookom]

You can display the value using the format property. If you actually want to calculate, I would use:

cInt([0to5Rank] * 10)/10

Duane
Hook'D on Access
MS Access MVP

 

[TJVFree]

Duane that calculation worked great. Thanks for showing me it

 

[dhookom]

You can also use the Round() function like:

Round([0to5Rank],1)

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

The original question asked if this can be done in the properties tab of the query. Set the format to fixed and decimal places to 1 for that field in the query builder.