I am trying to use the following sumiff in the Field section of the design platform for a query. I am using:
949 Office: Sum(IIf([Customer Info Table.Office]="949 S. Orange County",[ExtendedPrice],0))
It is coming back with "Data Type mistmatch"
Any idea how I can change it? I want it to add any fields with "949 S. Orange County" as the Office value.