G
Guest
Some help please from someone who is still learning!!
I have a report based on a query and I would like to add up the totals for
each column, ideally within each group.
My report at the moment is grouped by Region (This is sales data for a sales
force). It then has projected sales forecast for Jan to Dec as fields.
I would like to total the sales for each month for each region. I've put in
a unbound box with the 'Region Header' and under 'control source' put
=sum(Jan)+(Feb)+(March) etc etc. The problem is, it only seems to take
randomly one value from one customer from each of the regions and put's this
as the total. So, for example, if under Region 1, I had 'Kate's Cafe' and
sales data for Jan-Dec and 'Dave's Garage' and sales data etc, it might pick
the sales data from Kate's Cafe as the total for Jan....
If I move this box onto the Report Footer, when I look at it in Print
Preview it says '#Error'
Any ideas? Sure it's something simple that I've missed!
I have a report based on a query and I would like to add up the totals for
each column, ideally within each group.
My report at the moment is grouped by Region (This is sales data for a sales
force). It then has projected sales forecast for Jan to Dec as fields.
I would like to total the sales for each month for each region. I've put in
a unbound box with the 'Region Header' and under 'control source' put
=sum(Jan)+(Feb)+(March) etc etc. The problem is, it only seems to take
randomly one value from one customer from each of the regions and put's this
as the total. So, for example, if under Region 1, I had 'Kate's Cafe' and
sales data for Jan-Dec and 'Dave's Garage' and sales data etc, it might pick
the sales data from Kate's Cafe as the total for Jan....
If I move this box onto the Report Footer, when I look at it in Print
Preview it says '#Error'
Any ideas? Sure it's something simple that I've missed!