Number value to text value

[drvs]

Hi,

I have a field with numbers and now i want a query to display the numbers as text values.

Field1
1
2
3

Im my query i want to see

Field1
Test1
Test2
Test3

Tia,

Dennis

 

[kermit01de]

SELECT "Test" & [Field1] AS Testfield
FROM YourTable;


--------------------------------------
>>>>>> Bugs will appear in one part of a working program when another 'unrelated' part is modified <<<<<

 

[drvs]

Thx kermit01de

But i was looking for something else.

What i wanted was

Table
[field1]
1
2
3

And in the query as

Query
[field1]
Welcome
nextday
weekend

So if the vlaue in table field = 1

then i wanted it to say Welcome in the query, and if the value = 2 then nextday and so on.

Tia,


Dennis

 

[kermit01de]

I think you should have another table with your desired values

eg.

ID - Text
1 - Welcome
2 - nextday
3 - weekend
4 - and so on

and then create a simple query ...


--------------------------------------
>>>>>> Bugs will appear in one part of a working program when another 'unrelated' part is modified <<<<<