By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,747 Members | 1,308 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,747 IT Pros & Developers. It's quick & easy.

Table

P: n/a
I want to convert numbers to text within a table, how can I do
this.... I have tried an update query but it didnt come up with
anything...

1 = Inactive
2 = Due
3 = Received
4 = Problems
5 = Cleared

Please help - can do it in a form but not on the table.

Thanks

Elaine

May 24 '07 #1
Share this Question
Share on Google+
2 Replies

P: n/a
On May 24, 10:29 am, Elainie <Elaine.Macint...@bsc.wales.nhs.uk>
wrote:
I want to convert numbers to text within a table, how can I do
this.... I have tried an update query but it didnt come up with
anything...

1 = Inactive
2 = Due
3 = Received
4 = Problems
5 = Cleared

Please help - can do it in a form but not on the table.

Thanks

Elaine
Did you change the data type in the table definition?

May 24 '07 #2

P: n/a
On May 24, 11:17 am, DavidB <j...@yahoo.comwrote:
On May 24, 10:29 am, Elainie <Elaine.Macint...@bsc.wales.nhs.uk>
wrote:
I want to convert numbers to text within a table, how can I do
this.... I have tried an update query but it didnt come up with
anything...
1 = Inactive
2 = Due
3 = Received
4 = Problems
5 = Cleared
Please help - can do it in a form but not on the table.
Thanks
Elaine

Did you change the data type in the table definition?
After you have done that you realize that what is in the field is no
longer trhe number 1 but the text "1" thus your update query has to
update "1" to "Inactive" and specifically NOT update 1 to "Inactive".

May 24 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.