report question

[DPUser]

I have created a report that contains a textbox with its control source property pointing to a field in a table making the report show what the table contains. The problem is that I want the text box to show either "buy" or "sell" based on what the field contains. For example, the field in the table contains a "I" or "A" and the report should show "Buy" if the field is "A" or "Sell" if the field is an "I". Is there any way that I could do this without creating a new table and dumping the contents of an existing table into the table?


Thank you

 

[RivetHed]

Hi, try creating another text box with this as it's control source
IIF([MyTextbox]="I","Sell",IIF([MyTextbox]="A","Buy","Not Specified&quot)

this should do it, just put in your textbox name