Expression Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...

Exp:IIf([Corrected_Reason] = "Reason Correct",[Reason],[Corrected_
Reason])
 
fredg said:
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.
Click to expand...

Exp:IIf([Corrected_Reason] = "Reason Correct",[Reason],[Corrected_
Reason])
Click to expand...

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
 
Back
Top