Expression Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 16 Mar 2007 22:26 GMT

I am trying to build an expression for this query. I need a query that will
display [Corrected_Reason] unless [Corrected_Reason] is "REASON CORRECT" Then
give me [Reason]. Here is what I have so far:

IIf("REASON CORRECT[Corrected_Reason]",[Reason],[Corrected_Reason])

It is just displaying the [Corrected_Reason] row.

Reply to this Message

fredg - 16 Mar 2007 22:43 GMT

> I am trying to build an expression for this query. I need a query that will
> display [Corrected_Reason] unless [Corrected_Reason] is "REASON CORRECT" Then
[quoted text clipped - 3 lines]
>
> It is just displaying the [Corrected_Reason] row.

Exp:IIf([Corrected_Reason] = "Reason Correct",[Reason],[Corrected_
Reason])

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Mike - 17 Mar 2007 02:51 GMT

> > I am trying to build an expression for this query. I need a query that will
> > display [Corrected_Reason] unless [Corrected_Reason] is "REASON CORRECT" Then
[quoted text clipped - 6 lines]
> Exp:IIf([Corrected_Reason] = "Reason Correct",[Reason],[Corrected_
> Reason])

IIf([Corrected_Reason]="Reason Correct",[Reason],[Corrected_Reason]) worked,
but now its filtering my results. I was showing 12000 records, now I am only
getting 425. What can I do to get all of the records to show up?

Thanks,
Mike

Reply to this Message