Summing Expressions Containing Aggregate Functions

  • Thread starter Thread starter Doris Morris
  • Start date Start date
D

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?
 
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
 
Back
Top