Hi All Again
I receive information in a database with a shorten version of details
Example CS = International and LS = Local.There are 23 different types of these abbreviations.
Is there any way of replacing the shorten version with the correct version in a report.I have created a table with the both versions.
Thanks


Brendan Bartley

__________________
Brendan Bartley

TO use States in the US as an example, what I do is have a look up table that has these fields:

tblState
StateID = text, like "DE," "MD," etc as PK
StateName = text, like "Delaware," "Maryland," etc.

I allow the user to pull up the abbreviation in the forms, and then when I run a report for addresses, for example, I pull the StateName column instead of the PK field. The nice thing is, even if you only have the State abbrev in the table, you can add the StateName field at any time and replace it in all your queries.

Does this help?


mmcdonal

Thanks for you're reply
The only problem I have is that the details are all ready in the database how do I update the data for the report
Thanks

Brendan Bartley