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


"TKM" wrote:

> 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?

"Lord Kelvan" wrote:

> 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
>

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


"TKM" wrote:

> 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?
>
> "Lord Kelvan" wrote:
>
> > 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
> >

where is it in 2007

"KARL DEWEY" wrote:

> 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
>
>
> "TKM" wrote:
>
> > 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?
> >
> > "Lord Kelvan" wrote:
> >
> > > 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
> > >

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


"KARL DEWEY" wrote:

> 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
>
>
> "TKM" wrote:
>
> > 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?
> >
> > "Lord Kelvan" wrote:
> >
> > > 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
> > >

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" wrote:

> SELECT tblCoinInfo.InfoID, tblCoinInfo.CoinType, tblCoinInfo.MM,
> tblMM.[MM(MintMark)]
> FROM tblMM INNER JOIN tblCoinInfo ON tblMM.MMID = tblCoinInfo.MM;
>
>
> "KARL DEWEY" wrote:
>
> > 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
> >
> >
> > "TKM" wrote:
> >
> > > 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?
> > >
> > > "Lord Kelvan" wrote:
> > >
> > > > 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
> > > >

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" wrote:

> 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" wrote:
>
> > SELECT tblCoinInfo.InfoID, tblCoinInfo.CoinType, tblCoinInfo.MM,
> > tblMM.[MM(MintMark)]
> > FROM tblMM INNER JOIN tblCoinInfo ON tblMM.MMID = tblCoinInfo.MM;
> >
> >
> > "KARL DEWEY" wrote:
> >
> > > 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
> > >
> > >
> > > "TKM" wrote:
> > >
> > > > 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?
> > > >
> > > > "Lord Kelvan" wrote:
> > > >
> > > > > 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
> > > > >

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" wrote:

> 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" wrote:
>
> > 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" wrote:
> >
> > > SELECT tblCoinInfo.InfoID, tblCoinInfo.CoinType, tblCoinInfo.MM,
> > > tblMM.[MM(MintMark)]
> > > FROM tblMM INNER JOIN tblCoinInfo ON tblMM.MMID = tblCoinInfo.MM;
> > >
> > >
> > > "KARL DEWEY" wrote:
> > >
> > > > 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
> > > >
> > > >
> > > > "TKM" wrote:
> > > >
> > > > > 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?
> > > > >
> > > > > "Lord Kelvan" wrote:
> > > > >
> > > > > > 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
> > > > > >