Quick and easy I hope - report returning ID instead of name (content)

[dwcrockford]

I have designed a report based on a query. The query returns the result of the content of the field properly (text - company name). When I pull a report based on that query, the report displays the company's ID number instead of the associated name.

Again, the QUERY is returning the correct content, but the report based on the query is not.

Explanations/fixes please.

D

 

[Gingertrees]

Please post the code of the query.

 

[Micron]

In design view, click on the report control that's showing the ID and look at the property sheet. Then make sure it's bound to the correct query field. Also, make sure it's the right query. I know that might sound dumb, but I've played around with variations of a query and accidentally used the wrong one for a report. You might have intended to include the ID on the report but are missing a control for the company name (or it's invisible).

 

[HiTechCoach]

I have designed a report based on a query. The query returns the result of the content of the field properly (text - company name). When I pull a report based on that query, the report displays the company's ID number instead of the associated name.

Again, the QUERY is returning the correct content, but the report based on the query is not.

Explanations/fixes please.

D

Sounds like you have encountered the Evils of Lookup Fields in Tables (click here)

You will need to add the related customer table and join on the customer ID. Add the desired fields from the Customer table to the query output