Hi,
I am trying to replicate a simple sumifs from excel to access & struggling to make it work. The data I have is:
Ref------ Month---------- Days
1 ----------May 2018----- 12
1 ----------May 2018----- 10
2 ----------May 2018----- 11
2 ----------June 2018----- 30
3 ----------May 2018------ 13
3 ---------May 2018------- 14
3 ---------May 2018------- 15
& what I need is a totals column with the double criteria of ref & month so the output would be as follows:
Ref -------Month----------- Days----- Total
1 ----------May 2018------- 12------- 22
1 ----------May 2018 -------10------- 22
2 ----------May 2018------- 11------- 11
2 ----------June 2018------ 30------- 30
3 ----------May 2018------- 13------- 42
3 ----------May 2018------ 14-------- 42
3 ----------May 2018------ 15-------- 42
I have attempted using DSum but how should this be used with the criteria not being fixed or based on a user entered value?
Thanks for any advice
I am trying to replicate a simple sumifs from excel to access & struggling to make it work. The data I have is:
Ref------ Month---------- Days
1 ----------May 2018----- 12
1 ----------May 2018----- 10
2 ----------May 2018----- 11
2 ----------June 2018----- 30
3 ----------May 2018------ 13
3 ---------May 2018------- 14
3 ---------May 2018------- 15
& what I need is a totals column with the double criteria of ref & month so the output would be as follows:
Ref -------Month----------- Days----- Total
1 ----------May 2018------- 12------- 22
1 ----------May 2018 -------10------- 22
2 ----------May 2018------- 11------- 11
2 ----------June 2018------ 30------- 30
3 ----------May 2018------- 13------- 42
3 ----------May 2018------ 14-------- 42
3 ----------May 2018------ 15-------- 42
I have attempted using DSum but how should this be used with the criteria not being fixed or based on a user entered value?
Thanks for any advice