Rounding expression in a query

M

Mike

I have a query that calculates a percentage and when I use the round in the
expression builder and go to zero decimal points it works perfectly. I need
it to round to 2 decimal points. When I try that it extends out as many as
needed. Here is the expression:
EM_RepPer_Calc:
IIf([SC_ExecMgmnt_Tot_Ees]=0,0,Round(([tblScoreCard_Data]![SC_ExecMgmnt_Rep_Num]/[tblScoreCard_Data]![SC_ExecMgmnt_Tot_Ees]),2))
 
J

John Spencer (MVP)

The expression looks good and should be returning what you want. I just
tested a similar expression in a query in Access 2003 (sp2) and got the
expected rounded result returned.

What version of Access are you using
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 

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

Rounding Question 3
Use In() Expression as Query criteria with guts from Function 1
Sum and DateDiff 2
Decimal places and Date Range in Expression Builder 2
Expression Builder help. 8
Sum points per round when winning team takes every game 1
Help with expression not rounding properly 2
IFF causing a prompt in a query 1

Top