bmoos1@yahoo.com wrote:[color=blue]
> I have two reports: 2004 New Enrollments and 2004 Cancellations.
>
> 1. Each report shows by month:
> "Monthly", "BiMonthly"([BiMonthly]*2), "Weekly" ([Weekly]*52/12),
> "Total Monthly" ([monthly]+[BiMonthly]+[Weekly]) and "Projected
> Annual"([Total Monthly]*12).
>
> 2. At the end of the report is the "Grand Total Projected
> Annual"(=sum([Projected Annual])
>
> I need a report that gives GrandTotal Projected Annual enrollment minus
> the GrandTotal Projected Cancellations for a real total revenue.[/color]
In a group total or report footer you could have 3 controls: Annual,
Cancellation, Net. The net's control source would be
=[Annual] - [Cancellation]
You can use a Dsum() control source for Cancellation. Ex:
=Dsum("Amount","TableName","Type = 'C' And Year(EnrollDate) = 2004")
[color=blue]
>
> By the way, my Grand Total Projected Annual on the 1st report I created
> works, but on the other report (cancellation) which I copied and made
> the necessary changes as to Control Source. What's up with that?
> Thank you so much. Blessings,
> Barbara
>[/color]
