I've been using the Sum iif statement for a few reports because it allows me to customize my report layout better than using regular queries.
I have a list of clients who have received service hours but I need to total those numbers by month and county. I have a query that pulls the month (user selects which month with a list box), total hours and the counties.
In the report I have the following statement in a text box to sum Jefferson county client hours:
=Sum(IIf([county]="Jefferson",[total hours this payperiod],0))
I need a similar total for all counties OTHER than Jefferson. Is there a way to update this statement so it pulls all the other counties without me having to list them in the statement? I'm worried that if the user adds another client from another county I dont have listed, the report will be inaccurate.
As you can see, I'm pretty new at sql, so this is the best way I've found to total the hours on a report.