Hi everyone
I have a problem here to get the sum of the same category in the same month:
Month GpName Name Cal1 Cal2
01/08/2015 Red Mary 1 20
01/08/2015 Red John 2 21
01/08/2015 Green Jack 3 22
01/08/2015 Green Simon 4 23
01/08/2015 Yellow Jo 5 24
01/08/2015 Yellow Will 6 25
01/09/2015 Red Mary 7 26
01/09/2015 Red John 8 27
01/09/2015 Green Jack 9 28
01/09/2015 Green Simon 10 29
01/09/2015 Yellow Jo 11 30
01/09/2015 Yellow Will 12 31
01/10/2015 Red Mary 13 32
01/10/2015 Red John 14 33
01/10/2015 Green Jack 15 34
01/10/2015 Green Simon 16 35
01/10/2015 Yellow Jo 17 36
01/10/2015 Yellow Will 18 37
I would like to create a formula in Access query, so as to sum up the same GpName in the same month and get the percentage as below: Sum of gpName Red (1 + 2)/(20 + 21) = 7%
Results
01/08/2015 Red 3 41 7%
01/08/2015 Green 7 45 16%
01/08/2015 Yellow 11 49 22%
Please could anyone help? Many thanks.
I have a problem here to get the sum of the same category in the same month:
Month GpName Name Cal1 Cal2
01/08/2015 Red Mary 1 20
01/08/2015 Red John 2 21
01/08/2015 Green Jack 3 22
01/08/2015 Green Simon 4 23
01/08/2015 Yellow Jo 5 24
01/08/2015 Yellow Will 6 25
01/09/2015 Red Mary 7 26
01/09/2015 Red John 8 27
01/09/2015 Green Jack 9 28
01/09/2015 Green Simon 10 29
01/09/2015 Yellow Jo 11 30
01/09/2015 Yellow Will 12 31
01/10/2015 Red Mary 13 32
01/10/2015 Red John 14 33
01/10/2015 Green Jack 15 34
01/10/2015 Green Simon 16 35
01/10/2015 Yellow Jo 17 36
01/10/2015 Yellow Will 18 37
I would like to create a formula in Access query, so as to sum up the same GpName in the same month and get the percentage as below: Sum of gpName Red (1 + 2)/(20 + 21) = 7%
Results
01/08/2015 Red 3 41 7%
01/08/2015 Green 7 45 16%
01/08/2015 Yellow 11 49 22%
Please could anyone help? Many thanks.