Convert a Number data type to a Text data type

  • Thread starter Thread starter TKM
  • Start date Start date
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?
 
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
 
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?
 
Post the SQL of your query. Open in design view, click on VIEW - SQL View,
highlight all, copy, and paste in a post.
 
SELECT tblCoinInfo.InfoID, tblCoinInfo.CoinType, tblCoinInfo.MM,
tblMM.[MM(MintMark)]
FROM tblMM INNER JOIN tblCoinInfo ON tblMM.MMID = tblCoinInfo.MM;
 
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...
 
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...
 
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...
 
Back
Top