Query Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
MUSIWA said:
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
Click to expand...


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.
 
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.
 
MUSIWA said:
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.

MUSIWA said:
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
Click to expand...
Click to expand...


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.
 
Back
Top