I could not get the DLookup to work correctly, so I kept Reviewing formula's then noticed that I my calculation was; =Sum([B])/([A]), which was incorrect, it should have been: =Sum([B])/Sum([A]). Which means I kind of misdirected you in my first question. Thanks for your help.
Michael
Micheal
Last Activity: Aug 23 '07, 06:13 PM
Joined: Aug 17 '07
Location:
-
-
Report "Percentage claculation of Totals and Grand Totals"
Greetings Access Group,
Being relatively new to Access, I try to work through problems on my own and have been very successful, although I have a conundrum that I have been working on for two days (total 10 hours) and I have yet to resolve it. please excuse me for my lack of terminology, I will try to provide you with the best of information.
I currently have a report that contains 2 totals and the percentage of the...
No activity results to display
Leave a comment: