Percentage in a query

[SpiritedAway]

I have a simple query with this SQL

SELECT [Copy Of QueryLevel1Sum].TotalStatus, [Copy Of QueryLevel1Sum]![TotalStatus]/100 & "%" AS Percentage
FROM [Copy Of QueryLevel1Sum]
GROUP BY [Copy Of QueryLevel1Sum].TotalStatus, [Copy Of QueryLevel1Sum]![TotalStatus]/100 & "%";

Which produces this result:

TotalStatus Percentage
1 0.01%
4 0.04%
5 0.05%
Total 10

I'm trying to get the Percentage to say

10% instead of 0.01%
40% instead of 0.04%
50% instead of 0.05%

Can anyone advise how the best way to achieve this?

I'm using Access 2007

 

[WayneRyan]

S,

([Copy Of QueryLevel1Sum]![TotalStatus]/100) * 100

will give you the correct answer.

Change to * 1000 to give you requested answer.

You can also encapsulate the whole thing in the format function to give you a consistent answer.

Wayne