Changing a fields resulting text

  • Thread starter Thread starter Max
  • Start date Start date
M

Max

I have a field [INCOMING/OUTGOING]. Data is either "I"
(incoming) or "O" (outgoing). In the report I want to
have "INCOMING" or "OUTGOING" to print instead of "I"
or "O". How do I do this? Is it through criteria or done
back in the query?

Any assistance would be greatly appreciated.
 
Hi Max.
In the unbound textbox on your report enter:
=IIF([INCOMING/OUTGOING] = "I","Incoming","Outgoing")
Make sure the texbox is named different from any of the
data elelements of your query.
You could instead include this in the field in the query
like:
InOut:IIF([INCOMING/OUTGOING] = "I","Incoming","Outgoing")
Than you would put a textbox in your report with
sourcedata [InOut]
Hope this helps.
Fons
 
Max said:
I have a field [INCOMING/OUTGOING]. Data is either "I"
(incoming) or "O" (outgoing). In the report I want to
have "INCOMING" or "OUTGOING" to print instead of "I"
or "O". How do I do this? Is it through criteria or done
back in the query?
Click to expand...


You calculate that in either the query or in a text box:

=IIf([INCOMING/OUTGOING] = "O", "OUTGOING", "INCOMING")
 
Back
Top