Recent content by rmsimps

If Attending = 75 and Dropped = 25 your formula would be =(75+25)/75 which breaking it down would give (100) / 75 which = 1.3333.... My is: =75/(75+25) *100 = 75/100 * 100 = 75% which is correct answer. Unless access does not follow the rules of mathematics to calculate a percent.

The formula would be =Attending/(Attending + Dropped) * 100 to get the correct percent Attending and Dropped are not variables however. They are generated by doing a count on the group. the words Dropped and Attending are generated from the following in a Text Control box. Attending is one of...

Want a Access Report that will do the following Print each group, give the number attending for that group, give the number not attending for that group, and give the % attending. Sample: Groups Attending Dropped % Attending 1st Group 90 10 90% 2nd Group 18 6...

I solved my own problem with help from isladogs and Micron. Thank you. :) You jogged something in my brain. I was placing my code into the wrong spot. I created a unbound text box and put the text in the control source. It works great.

I have a report that if the value of a boolean is false it will print "Dropped", and if true will print "Attending". I had it working at one time, but will not work now. In the caption of the label I put the following code: =IIF([Attending] = True, "Attending", "Dropped") where [Attending] is...

I am a new user to the forum. I am looking how to usie IIF in a report so that it will print the output depending on the boolean value.