i have a sales table that includes the following fields; date, amount, custname
the report has grouping for cust name
i would like the report to show the the cust name and the amount purchased each month
in the group footer i was intending to have 12 controls with each one doing sum, iif for that month
question is - where do i list the field i want the sum to act on in the following equation
=Sum(IIf([DATE] Between (12/31/2014) And (1/31/2015),0))
the report has grouping for cust name
i would like the report to show the the cust name and the amount purchased each month
in the group footer i was intending to have 12 controls with each one doing sum, iif for that month
question is - where do i list the field i want the sum to act on in the following equation
=Sum(IIf([DATE] Between (12/31/2014) And (1/31/2015),0))