Showing the text instead of ID

S

Sam

Hello,

I have two tables, Deposits and Offices. The report that I run shows the
[Deposits]OfficeID (which is linked to OfficeID in Offices) instead of
[Office]OfficeName. I have a relationship between the two different tables.

What I'd like to do is show the text of the office name in the report
instead of the unique ID that office was given.

Whenever I add another table to the design view in queries, it gives me a
type mismatch error so I cannot run the report.

How would I go about doing this?
 
M

Marshall Barton

Sam said:
I have two tables, Deposits and Offices. The report that I run shows the
[Deposits]OfficeID (which is linked to OfficeID in Offices) instead of
[Office]OfficeName. I have a relationship between the two different tables.

What I'd like to do is show the text of the office name in the report
instead of the unique ID that office was given.

Whenever I add another table to the design view in queries, it gives me a
type mismatch error so I cannot run the report.
Click to expand...


Adding the Offices table to the report's record source query
is the right thing to do. Are you sure that you are joining
the tables on the ID fields? If you are, then check to make
sure the ID field is the same type in both tables.
 

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

One to Many Relationship 2
How do I create a report based off of several Combo Box selections 4
Expression to link two tables together not working 5
Calculate beginning balance, but print details on report 3
Report Shows ID instead of Text 4
Show text instead of ID 4
ID field shows instead of text 1
ID number showing 1

Top