Report Filtering

  • Thread starter Thread starter Annelie
  • Start date Start date
A

Annelie

I have a report which totals in one column the estimated amount, and in the
column next to it the amounts billed (this comes from Quickbooks). In the
footer I total both columns and than I add sum(billed)/sum(estimate) which
gives me the percentage billed.

I need to filter it by:: isnull([jobEndDate] and %billed = 100%

But since I am dealing with calculated fields in the report footer, I can't
figure out how to get this.
 
Annelie

One approach would be to use queries (rather than the report) to derive the
calculated values, and queries to "filter" for reporting.
 
Yes, I created another query summing the totals by job and I created a new
field, where my if statement generated either "open" or "closed" job. Than I
attached that query to the main query for the report. Its now working fine,
thank you
 
Back
Top