Problem with Sum in Report

[fletch79]

I am new to reports and am having a problem.
I have billing numbers being listed that are associated with project names. To make the report readable and accurate I am hiding duplicates for the billing numbers. Below is an example of what I am doing.

Project Billing $ Delivery Name
A 20000.00 Chicago
(hidden $ here)New York
B 30000.00 Memphis
C 2000.00 Detroit

=Sum([BillingAmount])

I may have a few parts for each project but there is only one billing amount per project.

The sum is addidng everything (including the hidden value). Is there a way to only sum what is visible?

Any tip or help is greatly appreciated.

Thanks in advance!
Fletch

 

[randysmid]

Hi,
You may want to base the report on a query. In the query, you can then set the criteria for what is to be printed or not printed. I am not sure why New York is not to be printed, so you may have to add a field to the table indicating whether it is to be printed or not. For instance, you may only permit one copy of any invoice to be printed. So, the initial setting for "bolPrinted" (boolean, indicating whether it had been printed or not, would be set to "No". After printing, this can be set to "Yes" with VBA code.

HTH,
Randy Smith
California Teachers Association