phendrena
01-05-2009, 03:53 AM
Hi there,
I was wondering if anyone would be able to help me with a problem that I am having producing a report.
I have setup a report, grouped by Team Leader.
The report is then setup to show Customer Managers.
The report should only list each customer manager once and produce a total for the various fields. In some instances the report is listing the customer manager more than once, in others is does produce a total.
Any idea why this is happening?
Also, I want 2 fields on the report to be totaled if the field data = "Yes".
These fields would be "Saved" and "Eligible" (Eligible should be totaled if Saved & Eligible both = "Yes"). In Excel i would've used a Sumproduct formula, how do i do this in access as i've tried a sumproduct formula with no success.
( =SUMPRODUCT(--([Saved]="Yes"),--([Eligible]="Yes")) ).
Thanks,
I was wondering if anyone would be able to help me with a problem that I am having producing a report.
I have setup a report, grouped by Team Leader.
The report is then setup to show Customer Managers.
The report should only list each customer manager once and produce a total for the various fields. In some instances the report is listing the customer manager more than once, in others is does produce a total.
Any idea why this is happening?
Also, I want 2 fields on the report to be totaled if the field data = "Yes".
These fields would be "Saved" and "Eligible" (Eligible should be totaled if Saved & Eligible both = "Yes"). In Excel i would've used a Sumproduct formula, how do i do this in access as i've tried a sumproduct formula with no success.
( =SUMPRODUCT(--([Saved]="Yes"),--([Eligible]="Yes")) ).
Thanks,