Get Query to show name instead of number

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

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using form to fill in query criteria not working 2
query or VBA 1
Show actual Text and not Primary Key Number 2
Query that will look for duplicate in two tables. 3
IIF Statement in a Query. 10
Problem with a form query 3
Show Data in Report and NOT Primary Key # 1
Dlookup Expression Error 2

Back
Top