Summing Expressions Containing Aggregate Functions

[Doris Morris]

In my report I am trying to sum how many franchised hotels we have in our
pipeline in North America. How do I tell the report to sum my field called
pipeline hotels if the owner type field equals franchised and the project
type field equals new build?

 

[Clifford Bass]

Hi Doris,

Your English description almost has you there. Make the control
source of the summary field this:

=Sum(IIf([owner type] = "franchised" and [project type] = "new build",
[pipeline hotels], 0)

If you are really wanting a count, change the [pipeline hotels] to a 1.

Clifford Bass