Counting Checkboxes =Sum(Abs([#OfDaysToClear]="yes"))

[Charles G via AccessMonster.com]

I need a report that includes:

Total Number of PSC tickets cleared in 1 day
Total Number of PSC tickets NOT cleared in 1 day

Currently I have this in my report design:
Textbox [PSC Tickets Cleared in 1 Day: =Sum(Abs([#OfDaysToClear]="yes"))
Textbox [PSC Tickets Not Cleared in 1 Day: =Sum(Abs([#OfDaysToClear]="no"))

Here is the query and fields that supply the report:

Select Query: PSC tickets monthly
[VaultNumber] [DateRcd] [PSC#] [Amount] [ErrorType] [DateCld]
[#OfDaysToClear] [OutOfOffice] [Comments]

My query runs smooth, however, when I run my report I get "This expression is
typed incorrectly, or it is too complex to be evaluated..."

-Charles-

 

[SusanV]

Hi Charles,

Try this:

Textbox "PSC Tickets Cleared in 1 Day" control source should be:
=Sum(Abs([#OfDaysToClear]="yes"))

Textbox "PSC Tickets Not Cleared in 1 Day" control source should be:
=Sum(Abs([#OfDaysToClear]="no"))

 

[Charles G via AccessMonster.com]

That seems to be what I already have. I keep getting a "complex error."

-Charles-

 

[Charles G via AccessMonster.com]

I got it. It was:

=Sum(Abs([#OfDaysToClear])) for Checked box

=Sum(Abs([#OfDaysToClear]+1)) for unChecked box

-Charles-