
Signature
Duane Hookom
MS Access MVP
Ok, I will try to do a little bit more detail. I tried the below expression
and got Type mismatch. Here is how my report should look:
Results
Should Be This
School Adams Middle
Employee Position Computer Education
How Many Half Days Absence 0
0
How Many Whole Days Absence 13
18
Total Absence 18
18
Alot of my calculations have been done in query, which is where my Expr1 and
Expr4 come from.
The total absence Count is correct. The formula used for that is:
=Sum([Expr1]*[expr4])
Half day count is correct, Formula is:
=Sum(IIf([expr4]=".5",1,0))
Whole Day is wrong and orginial formula that I was using was:
=Sum(IIf([expr4]="1",1,0))
I'm still very new to this, and I am catching on, but any more suggestions
would be greatly appreciated.
The total
> You really need to kick your development up a notch and not accept
> expression names like expr1 or expr4. If expr4 is numeric then ditch the
[quoted text clipped - 16 lines]
> >
> > Thanks
Duane Hookom - 22 May 2006 16:24 GMT
Isn't Expr4 numeric? If so, kill the quotes...
=Sum(IIf([expr4]=.5,1,0))
You can create descriptive column names in your query.

Signature
Duane Hookom
MS Access MVP
> Ok, I will try to do a little bit more detail. I tried the below
> expression
[quoted text clipped - 48 lines]
>> >
>> > Thanks