Multiple Criterias

[jamiesuperman420]

Hello!!

Here's what I'm trying to do: Make a query that returns results specifically for certain months, separated by county.

Here's what I have done: Made it so the counties are separated and they add up the fees if they're active. CC: IIf([PropertyCounty]="Los Angeles" And [SC Active],+[SC Fee]) ... Totaled by SUM

Here's what I can't do: Make it month-specific. I tried including the iif([Month]="Jan" etc, etc, in the Field, and got it working but it was too long for 12 months. Now I'm trying having lines in the CRITERIA: IIf([Month]="Jan",[SC Jan]=True), followed by February on the next line, etc, etc, but it's returning blank results, even with only January entered.

[SC Jan] is a checkbox saying whether or not the service is to be provided in that month.

I'm trying to avoid making 12 different queries.

Any help at all?? Thank you!!

 

[jamiesuperman420]

I guess it should be Multiple Criteria, eh?? Oops!!