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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with expression builder in a Query to retrieve wanted dates 2
Expression Builder 6
Expression Builder help. 8
Functions not working in Access 2007 Queries 9
Subject: Use of Folder in Expression Builder 3
How to retrieve dates that meets a criteria using Query? Exp Build 1
Help with expression builder in a select Query 2
Add Built in functions in Expression Builder 0

Top