RE: Summing an Expression

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



"Chaim" wrote:

> 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))

Chaim, after thinking about it, you're right. But how do I count the records
has you have seguested?
.