Query Values

[Guest]

I am not sure how to word this question but I made a query from lists whose
values are selected from a combo box. The query has the text values from the
combo boxes which is what I want but the report only show the IDs of the text
not the text. eg combo box column A has 1, column B has "Cheif" the control
name is [CC]. When I concatinate an expression in the report I want to say
="text "& [CC] and get (text cheif) instead I get (text 1). I am missing
something obviously. I tried to play around with the lookup on properties of
the query but I could not fix the problem

 

[Marshall Barton]

I am not sure how to word this question but I made a query from lists whose
values are selected from a combo box. The query has the text values from the
combo boxes which is what I want but the report only show the IDs of the text
not the text. eg combo box column A has 1, column B has "Cheif" the control
name is [CC]. When I concatinate an expression in the report I want to say
="text "& [CC] and get (text cheif) instead I get (text 1). I am missing
something obviously. I tried to play around with the lookup on properties of
the query but I could not fix the problem

Those lookup **fields**in a table are really confusing and I
strongly recommend against using them.

Presumably, each lookup field has a table with the id and
text. If so, then just add the lookup table to your query's
tables and make sure the join lines are between the
appropriate field in main table and the respecitve field in
each lookup table. Then you can use the lookup table's text
field in the query's field list.

 

[Guest]

Thanks I wish I can avoid the look up tables but unfortunately I have to have
them there otherwise I would have to type them in many times a day. There is
a lot that takes place based on the specific selection in the program.
Thankyou again I think I understand what you mean. It just seems to hard for
what I want to do with the report. Is there an easier way to tell the report
to display what is already on the query. Its ok if there is not.

 

[Marshall Barton]

Thanks I wish I can avoid the look up tables but unfortunately I have to have
them there otherwise I would have to type them in many times a day. There is
a lot that takes place based on the specific selection in the program.
Thankyou again I think I understand what you mean. It just seems to hard for
what I want to do with the report. Is there an easier way to tell the report
to display what is already on the query. Its ok if there is not.

I am not sure how to word this question but I made a query from lists whose
values are selected from a combo box. The query has the text values from the
combo boxes which is what I want but the report only show the IDs of the text
not the text. eg combo box column A has 1, column B has "Cheif" the control
name is [CC]. When I concatinate an expression in the report I want to say
="text "& [CC] and get (text cheif) instead I get (text 1). I am missing
something obviously. I tried to play around with the lookup on properties of
the query but I could not fix the problem

Please don't misunderstand my objection to using a lookup
**field** in a table with the idea of lookup tables. Lookup
tables are an important part of a form's user interface via
combo boxes and list boxes. They may occassionally even be
useful in a query.

However, using them directly in a table only obscures what
data is actually stored and leads to the confusion that you
ran into when trying to retrieve the lookup values.