RE: Summing an Expression
- From: "Chaim" <Chaim@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 26 Jul 2005 14:21:07 -0700
Mike,
If I'm reading this correctly, the only situation in which you get a '1' as
the value of Expr1 is when
[PUBLIC_T_DIARY_ADJ.CRED_DA_VAL] <> [PUBLIC_T_DIARY.CRED_DA_VAL]
Is that correct? Or is there a value reversal here?
If my reading is correct, maybe you should try substituting the simpler
expression and simply count the number of records where these two fields are
not the same?
--
Chaim
"Mike Johnson" wrote:
> I have the following expression in a query. I need to sum this colum. How?
>
> I tried changing the total to sum. No change in data. Still displays all
> records.
>
> Expr1:
> IIf([PUBLIC_T_DIARY_ADJ.CRED_DA_VAL]=1,0,IIf([PUBLIC_T_DIARY.CRED_DA_VAL]=1,0,1))
.
- Follow-Ups:
- RE: Summing an Expression
- From: Mike Johnson
- RE: Summing an Expression
- References:
- Summing an Expression
- From: Mike Johnson
- Summing an Expression
- Prev by Date: Is there a way to use a WatchDog???
- Next by Date: Re: newbie needs help comparing and viewing info from several tabl
- Previous by thread: Re: Summing an Expression
- Next by thread: RE: Summing an Expression
- Index(es):
Relevant Pages
|
