Field1Name |
Field2Name |
Field3Name |
Field4Name |
Field5Name |
Field6Name |
=Sum(WHERE [Field1] (<> null) AND (Between [1/1/2014] And [1/8/2014])) |
=Sum(WHERE [Field2] (<> null) AND (Between [1/1/2014] And [1/8/2014])) |
=Sum(WHERE [Field3] (<> null) AND (Between [1/1/2014] And [1/8/2014])) |
=Sum(WHERE [Field4] (<> null) AND (Between [1/1/2014] And [1/8/2014])) |
=Sum(WHERE [Field5] (<> null) AND (Between [1/1/2014] And [1/8/2014])) |
=Sum(WHERE [Field6] (<> null) AND (Between [1/1/2014] And [1/8/2014])) |
=Sum(WHERE [Field1] (<> null) AND (Between [1/8/2014] And [1/15/2014])) |
etc.. |
etc.. |
etc.. |
etc.. |
etc.. |
etc.. for every week of year |
etc.. for every week of year |
etc.. for every week of year |
etc.. for every week of year |
etc.. for every week of year |
etc.. for every week of year |