Look up - Shows ID number rather than name in a report

R

Ronnie

I have a report made from a query--It shows a purchase order number and
customer name. The query pulls a customer ID , but then looks up the
customer name. The query runs fine. The report only shows the customer
number. I cannot get it to show the name of the customer. Is there
something I can do to show the customer name instead of number. What am I
doing wrong. What can I do to correct this.
 
J

John Vinson

I have a report made from a query--It shows a purchase order number and
customer name. The query pulls a customer ID , but then looks up the
customer name. The query runs fine. The report only shows the customer
number. I cannot get it to show the name of the customer. Is there
something I can do to show the customer name instead of number. What am I
doing wrong. What can I do to correct this.
Click to expand...

It seems you are yet another victim of Microsoft's misdesigned
so-called Lookup feature:

http://www.mvps.org/access/lookupfields.htm

Your table APPEARS to contain the customer name. It doesn't; it
contains the customer ID, which is concealed from your view by the
Lookup. This doesn't carry over to reports.

But it's simple to solve: instead of basing your report on the Table,
base it on a query joining your purchase order table to the customer
table. Pull the customer name field from the Customer table, rather
than using the lookup field in the purchase order table.

John W. Vinson[MVP]
 
Top