Convert a Number data type to a Text data type

T

TKM

I have my query set up to place a number instaed of the actual selection to
go into my table. This is based on a lookup from another table. I.E. You
select a selection from a combo box and it places a number not the text into
my table. How do I access the actual text in a seprate query so I can use the
info in my report?
 
L

Lord Kelvan

first you should use lookup tables

to access it in a query you need to have both tables active in the
query and then select the text field.

Regards
Kelvan
 
T

TKM

I have it in two seprate tables (lookup) the relationship is one to many one
seller to many coins. I still get the number instaed of the text. is the join
wwrong or? I have both fields in the query. Should be simple but?
 
K

KARL DEWEY

Post the SQL of your query. Open in design view, click on VIEW - SQL View,
highlight all, copy, and paste in a post.
 
T

TKM

SELECT tblCoinInfo.InfoID, tblCoinInfo.CoinType, tblCoinInfo.MM,
tblMM.[MM(MintMark)]
FROM tblMM INNER JOIN tblCoinInfo ON tblMM.MMID = tblCoinInfo.MM;
 
K

KARL DEWEY

You did not say which field was the lookup so I assume it should be
[MM(MintMark)]
Try this --
SELECT tblCoinInfo.InfoID, tblCoinInfo.CoinType, tblMM.[MM(MintMark)]
FROM tblCoinInfo LEFT JOIN tblMM ON tblMM.MMID = tblCoinInfo.MM;

--
KARL DEWEY
Build a little - Test a little


TKM said:
SELECT tblCoinInfo.InfoID, tblCoinInfo.CoinType, tblCoinInfo.MM,
tblMM.[MM(MintMark)]
FROM tblMM INNER JOIN tblCoinInfo ON tblMM.MMID = tblCoinInfo.MM;


KARL DEWEY said:
Post the SQL of your query. Open in design view, click on VIEW - SQL View,
highlight all, copy, and paste in a post.
Click to expand...
Click to expand...
 
T

TKM

karl,

You are right about the lookup table. However I still get a mismatch in my
expression. I know its not me or you. This application (07) was put ontop of
a test environment and I have been getting crazy responses ever sense it was
installed. I am done until I get a new laptiop. Thanks so much for your help!

KARL DEWEY said:
You did not say which field was the lookup so I assume it should be
[MM(MintMark)]
Try this --
SELECT tblCoinInfo.InfoID, tblCoinInfo.CoinType, tblMM.[MM(MintMark)]
FROM tblCoinInfo LEFT JOIN tblMM ON tblMM.MMID = tblCoinInfo.MM;

--
KARL DEWEY
Build a little - Test a little


TKM said:
SELECT tblCoinInfo.InfoID, tblCoinInfo.CoinType, tblCoinInfo.MM,
tblMM.[MM(MintMark)]
FROM tblMM INNER JOIN tblCoinInfo ON tblMM.MMID = tblCoinInfo.MM;


KARL DEWEY said:
Post the SQL of your query. Open in design view, click on VIEW - SQL View,
highlight all, copy, and paste in a post.
--
KARL DEWEY
Build a little - Test a little


:

I have it in two seprate tables (lookup) the relationship is one to many one
seller to many coins. I still get the number instaed of the text. is the join
wwrong or? I have both fields in the query. Should be simple but?

:

first you should use lookup tables

to access it in a query you need to have both tables active in the
query and then select the text field.

Regards
Kelvan
Click to expand...
Click to expand...
Click to expand...
 
K

KARL DEWEY

Check the DataType of tblMM.MMID and tblCoinInfo.MM. They must match such
as autonumber and long integer or single and single.
--
KARL DEWEY
Build a little - Test a little


TKM said:
karl,

You are right about the lookup table. However I still get a mismatch in my
expression. I know its not me or you. This application (07) was put ontop of
a test environment and I have been getting crazy responses ever sense it was
installed. I am done until I get a new laptiop. Thanks so much for your help!

KARL DEWEY said:
You did not say which field was the lookup so I assume it should be
[MM(MintMark)]
Try this --
SELECT tblCoinInfo.InfoID, tblCoinInfo.CoinType, tblMM.[MM(MintMark)]
FROM tblCoinInfo LEFT JOIN tblMM ON tblMM.MMID = tblCoinInfo.MM;

--
KARL DEWEY
Build a little - Test a little


TKM said:
SELECT tblCoinInfo.InfoID, tblCoinInfo.CoinType, tblCoinInfo.MM,
tblMM.[MM(MintMark)]
FROM tblMM INNER JOIN tblCoinInfo ON tblMM.MMID = tblCoinInfo.MM;


:

Post the SQL of your query. Open in design view, click on VIEW - SQL View,
highlight all, copy, and paste in a post.
--
KARL DEWEY
Build a little - Test a little


:

I have it in two seprate tables (lookup) the relationship is one to many one
seller to many coins. I still get the number instaed of the text. is the join
wwrong or? I have both fields in the query. Should be simple but?

:

first you should use lookup tables

to access it in a query you need to have both tables active in the
query and then select the text field.

Regards
Kelvan
Click to expand...
Click to expand...
Click to expand...
 
Top