Get Query to show name instead of number

S

Stockwell43

Hello,

I have a form with a CBO that has a two column table one for ID(autonumber)
and one for Department(text). When clicking on the CBO on the form, I can get
the department name appears but when it saves to the main table, the number
is saved not the name. That's fine but when I run the query I don't want the
number because I need to show the name on a report. Is there a way to do this
that I am not understanding?

Thanks!!
 
C

Carl Rapson

In your query, join the Department table to your main table on the
Department ID field. Then, you can select the Department name field in the
query and use it on a report.

Carl Rapson
 
K

Klatuu

you will need to use a query rather than a table as the record source of the
report. In the query, you will include the department table and join it to
the other table on the ID number. Then use the name field of the query in
the report.
 
Top