Rounding expression in a query

  • Thread starter Thread starter Mike
  • Start date Start date
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))
 
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
 
Back
Top