I am trying to do a sumif formula that isn't working. If the value of the Office is "949 S. Orange County" I want it to sum the data. I am using the below syntax. When I run the querry it asks me to Enter Parameter Value for Office.Customer Info Table. If I type in "949 S. Orange County" then it works properly I'd like to to look for it without asking me to enter it. Any ideas?
Sum(IIf([Office].[Customer Info Table]="949 S. Orange County",[ExtendedPrice],0)) AS [949 Office]