Capping Field Value

[mtownbound]

I'm adding weighting to my issue fields which will cause some of my txtIssueRates to be >100%(It's percentage format so it's really 1). For example, rather than having a 300% Issue Rate, I'd like to cap it so that anything over 100% only shows up as 100%.

Currently, I'm using two fields to accomplish this, which is working, but checking to see if there's a more efficient way of doing it:

[txtIssueRate] =IIf(([txtIssues]=0),0,(([txtLevel3]*10)+([txtLevel2]*5)+([txtLevel1]*1))/[txtIssues])

[txtCapRate] =IIf([txtIssueRate]=0,"0.00%",(IIf([txtIssueRate]>1,"100%",([txtIssueRate]*100 & "%"))))


Thanks

 

[dhookom]

I'm not sure why you use this:
[pre][txtCapRate] =IIf([txtIssueRate]=0,"0.00%",(IIf([txtIssueRate]>1,"100%",([txtIssueRate]*100 & "%"))))[/pre]

rather than just
[pre][txtCapRate] = IIf([txtIssueRate]>1,"100%",[txtIssueRate]*100 & "%")[/pre]

Duane
Hook'D on Access
MS Access MVP

 

[mtownbound]

Great,thanks again!