Alternate Text?

[cdoyle]

Hi,

I'm working on a report, and I've been asked to do something I'm not really sure how to do.

Is there a way in a report to have alternate text display depending on the value of a field?

So say I have a report that would normally read like this.

Field #1..........Field #2
XX.............a bunch of text for this record
YY.............a bunch of text for this record.
ABC...........A bunch of text for this record.


What I would like to look is like this, For certain field type #1's, it will display something else??

Field #1....................Field #2
Coding problem........A bunch of text for this record.
Coding problem........A bunch of text for this record.
ABC........A bunch of text for this record

So any entries in Field #1 with XX or YY get a lable of 'coding problem'

Is this possible?

 

[KeithG]

You could create another table and have the value for field one and the text you want to display and link this new table to your query.