Converting List Values to Text in a Report

[cybrooksy]

This is so simple that I'm amazed it's so difficult to find out how to do!

I have a query which finds a selection of records from a table. These records have codes for certain fields; F for Forwards, B for Backwards etc. When I display these in my report I want to display Forwards and Backwards instead of F & B. How?

Thanks!

SJB

 

[James Dudden]

Are these codes actually stored anywhere? If so, if you use a combo on your report you should be able to set this up to work.
If not you can format it in the query behind the report. Do something like this:
Create new column in the query and put this in the name:
FormatCodes: iif([CODEFIELD] = "F","Forwards,iif([CODEFIELD] = "B", "Backwards,""))
Then in your report add the new field to your report.
NOTE: You will need to replace CODEFIELD with the code field name in your db.

 

[cybrooksy]

Thanks very much James - added field to report and have got desired outcome.

SJB