Is there a way to embed format instructions in Expressions?

I'm working on a report and I'm trying to get a percent completed figure (i.e. # of Homes Finished/total # of homes to be built = XX%) and I want the answer in ( ) so I built this expression.

="(" & ([# Currently Built]/[# To Be Built]*100) & "% )"

The only problem is that I can't get it to format properly.

Insted of getting (48%) I get (47.8231364782%).

Does anyone know how I might be able to get this to work? I've messed with all the properties, set Decimal places to 0, etc but can't figure this out.

Any help would be greatly appreciated!!

And I know there's another way to do this on the report with three seperate fields but I'd like to be able to do it in just one field so it looks better and automatically adjusts the ( ) based on the outcome.

Hi -

A97, which I'm using, doesn't have an embedded Round() function, so the following user-defined function substitutes. It should work with any Access version. After copying/pasting Function Roundx() to a new module, try this from the debug (immediate window):

Currently = 48
ToBe = 102
? "(" & roundx((currently / tobe *100),0) & "%)"
(47%)

HTH - Bob

Function roundx(ByVal pnum As Double, pPlace As Integer) As Double
Dim varNum As Double
Dim intPrefix As Integer 'equates to -1, 0 or 1
Dim varHold As Double

varNum = pnum
intPrefix = pnum / Abs(pnum)
varHold = 10 ^ pPlace
varNum = (Abs(pnum) * varHold) + 0.5
roundx = intPrefix * Int(varNum) / varHold

End Function