Change abbreviated code to its code description

[Jewel]

The field that is queried displays the abbreviared code (D, G, NAT). I want
to display the what each code means. I was querying on the code description
but the users have included comments that I do not want as part of the
results, therefore, I decided to change to the code and state what each code
means, e.g., D = Deny; G = Grant; NAT=No action taken.

 

[Albert D. Kallal]

Just build a table with the two collums

CodeS Description
D Deny
G Grant

etc...


Then, for your report, just build a query. Drop in the reports main table,
and then the above table. Draw a join line between the two, make it a left
join..and you then thus drop in the above Description field. Use that column
in the report in place of the Code....

 

[Jewel]

It worked! I thought I could hardcode what each code meant in a formula like
it is done in Crystal Reports. Thank you.