MS Access application

[Prachi]

Hi

I am trying to create a whole application in MS access.The queries have been
pulled out from tables (In sql database).From here I have to build a form
using these fields (for which I am using the report writer).
My problem is
There is one field in the table which has numbers that I want to be displayed
in Text on my report(will be a excel sheet)
Say for example field name is a which could have either of the foll values
1-Canada
2-Japan
3-US
4-India
So instead of the number I want to display the actual names they stand for.
Being a novice to MS access
application I am stuck as i dont know the right way to do this.Please can
anyone help me.I would really appreciate it

 

[Jeff Boyce]

Prachi

You don't mention:
1. where you are trying to display the text value
2. how many columns are used to hold the # value and the text value.

If you use a combo box on a form, you can 'hide' one column and display
another.

If your data is stuffed into a single column (not a good database design
practice), you can use the Left(), Mid(), Right() and Instr() functions to
parse out the various portions.

Regards

Jeff Boyce
Microsoft Office/Access MVP