ASP.NET, SQL Server, WPF, C#, VB.NET

Thanks to those who provided me guidance to transale code to text in the 
 
form.  I have the same requirements in generating report.  I used the Report 
 
Wizard to create report from a table.  The field (jobclass) that contains the 
 
code still shown as number 1,2,3 in the report as it is generated. 
 
Wonder if I can write some code to change each record's code as text ? 
 
For example change 1 to manager, 2 to supervisor, 3 to operator, etc. 
 
if yes, where it should be such that the report shows the translated text 
 
before it is previewed or printed ? 
 
Regards

Wellie wrote: 
 
If the text versions are stored in a different table then add that table to the 
 
query used by the report so you can pull the text in.  If they are not in a 
 
table and really are values starting with 1 then you can use the Choose 
 
function... 
 
=Choose([jobclass], "manager", "supervisor", "operator") 
 
-- 
 
Rick Brandt, Microsoft Access MVP 
 
Email (as appropriate) to... 
 
RBrandt   at   Hunter   dot   com