Calculating Percent in Report

[pipoconanan45]

Good day everyone, I'm complete novice when it comes to VBA and Database so please bear with me and Ill do my best to explain what my problem is.

Im trying to make a report where their are three textboxes (textbox1, textbox2, textbox3). What Im trying to do is calculate the percentage of the two values that are in textbox1 and textbox2 and result would be shown in textbox3.

These are the codes in the Control Source in both textbox.

Textbox1 - =Sum(IIf([FldID]="1",[BrgyCovered],0))
Textbox2 - =Sum(IIf([FldID]="1",[SubProjImp],0))

Both values from textbox1 and 2 came from a query.


I tried using this codes in the Control Source but they dont work.

Textbox3 - =([txtCARCov1]/[txtCARCov2])*100

for example textbox1=28 and textbox2=26 the answer should be textbox3=93%


The answer came out as 10769.23% instead of 93%

Thank you in advance.

[pbaldy]

Well, 28/26 is 1.0769, which is 107%, so times 100 would be 10769%. If you're formatting as % you don't want to multiply times 100.

[pipoconanan45]

im sorry i got it the wrong way it should have been 26/28*100 the answer then is 9285.71% is there a way to round this off to make it to 93%?

=([txtbox2]/[txtbox1])*100

[pbaldy]

Well, don't multiply by 100 for starters. You can wrap the formula in the Round() function if you want.

[pipoconanan45]

Thank you man. I got it, I didnt know that Ive been doing it the wrong way.

=FormatPercent(Round(([txtbox2]/[txtbox1]),2))

Im using this code now.

[pbaldy]

Happy to help.