Percentage

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

How can I have =(Count(*)/DCount("*","[qRefCalls]","[CALLED_ON] >=
#06/18/2007#"))*100 display on the report as 60%? There must be an easier
way than a concatenation.

Thanks,
 
I knew it had to be something simple like that! Thanks for taking the time
Have you tried NOT multiplying by 100 and then using the Format Property?
--
Duane Hookom
Microsoft Access MVP


Rod said:
Hello,

How can I have =(Count(*)/DCount("*","[qRefCalls]","[CALLED_ON] >=
#06/18/2007#"))*100 display on the report as 60%? There must be an easier
way than a concatenation.

Thanks,
Click to expand...
Click to expand...
 
Back
Top