Developer Forum

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?

Join that lookup table in your query and include the text field.
--
KARL DEWEY
Build a little - Test a little

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.
--
KARL DEWEY
Build a little - Test a little

where is it in 2007

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

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!

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