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

  • Thread starter Thread starter Charles G via AccessMonster.com
  • Start date Start date
C

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-
 
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"))
 
That seems to be what I already have. I keep getting a "complex error."

-Charles-
 
I got it. It was:

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

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

-Charles-
 
Back
Top