Query printing with different column headers

  • Thread starter Thread starter Mary C.
  • Start date Start date
M

Mary C.

I have a query and the calculations are working correctly. The only thing I
cannot get to work correctly is the following:

I have a field called Appeal and I want to print the different appeal.
What I want to print out is (if appeal = DFE print Define --- if appeal = SAD
print SADLY)
I wonder if I could do an SQL or something called Caption.

Appreciate an answer

Thank you
 
On Wed, 11 Mar 2009 03:56:08 -0700, Mary C.

No, but you can use the immediate if function:
select iif(Appeal="DFE", "Define", iif(Appeal="SAD", "SADLY", Appeal))
from SomeTable

-Tom.
Microsoft Access MVP
 
Back
Top