If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change abbreviated code to its code description
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. |
#2
|
|||
|
|||
Change abbreviated code to its code description
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.... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada |
#3
|
|||
|
|||
Change abbreviated code to its code description
It worked! I thought I could hardcode what each code meant in a formula like
it is done in Crystal Reports. Thank you. "Albert D. Kallal" wrote: 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.... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada |
Thread Tools | |
Display Modes | |
|
|