More than one function in the Expression Builder

S

Sharon

ExcpRate: nz([ExcpSum]/[smple_sz])*100

How do we add an additional function into the expression
builder? I would like 56.52173913043 to appear as 56.52
while still working in the expression builder with the
calculation listed above.
 
K

Kelvin

Just keep nesting the function in each other.

ExcpRate: round(nz([ExcpSum]/[smple_sz])*100,2)

Kelvin
 
V

Van T. Dinh

ExcpRate: Format(Nz([ExcpSum]/[smple_sz])*100, "0.00")

HTH
Van T. Dinh
MVP (Access)
 
Top