Sum totals in a report

mb1980

Registered User.
Local time
Today, 03:31
Joined
Aug 20, 2007
Messages
14
I am running a report from a query that has 2 yes/no fields in it, The report pulls through all information for the first field when at yes, what I am after is a total for each field so that it totals up every yes, if that makes sense lol. Example the first yes box has 20 fields pulled through so this one would be 20, if the second field shows 10 yeses this would total as 10. Now a bit trickier maybe, I want it to automatically percentage this so in this instance it would show 50%

I am a bit of a novice on access so please be as gentle as possible explaining this to me :rolleyes:

Thanks in advance anyone who can help me
 
Dsum

Have you investigated using DCount function in report module
You could use this twice to get both the Yes totals
from the reports table/query

Then when you've got the two numbers eg 120, 20 place in varibles
a and b

You then add to get a total these eg varible x = a + b

Using these 3 numbers (varibles) you could then calculate the percentage then display everything on the report in lables or textboxes

eg textbox1 = "Total: " & Cstr(x)
etc
 
Last edited:

Users who are viewing this thread

Back
Top Bottom