Report

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

Guest

I have a table that has drop-downs within them. When I run the report, the
report fills in the Name with the Primary I.D number. How do I get rid of
this number and replace it with the name within that Primary I.D field.
 
I have a table that has drop-downs within them. When I run the report, the
report fills in the Name with the Primary I.D number. How do I get rid of
this number and replace it with the name within that Primary I.D field.
Click to expand...

You're yet another victim of Microsoft's misdesigned, infuriating Lookup Field
misfeature.

Your table APPEARS to contain dropdown boxes and names. It doesn't. It
contains ID numbers; that fact is concealed from your view by the Lookup combo
box.

Base your report, not on the table, but on a Query joining your table to the
lookup table or tables. Pull the name fields from the joined table, and leave
the ID field out of the query grid.

John W. Vinson [MVP]
 
How would I create a Report joining my main table and Lookup column data?
I have a query now that says pulls directly from the main table that has the
two joined already. Can you explain how I would join these two in a query
when they are already joined on the table?

Thanks a lot man!

Andre Adams
 
That's the problem: the main table doesn't really have them joined together.
It only joins them for presentation purposes: all that's stored in the main
table is a foreign key pointing to the other table.

You have to create a query that contains both tables. The relationship
between them should be automatically created for you: if it isn't, you'll
have to do that yourself. You then drag the appropriate field(s) from the
second table along with the fields you want from the main table.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)
 
How would I create a Report joining my main table and Lookup column data?
Click to expand...

You wouldn't. You would create a Query joining the main table and the lookup
table... and then use that Query as the recordsource for the report.
I have a query now that says pulls directly from the main table that has the
two joined already. Can you explain how I would join these two in a query
when they are already joined on the table?
Click to expand...

If you know the name of the lookup table (I certainly don't) just add that
table to the query design window using the "Add Tables" tool. Access should
link it automatically. You can then select the text field from it, and include
that field in your report (in place of the numeric ID field).

John W. Vinson [MVP]
 
Back
Top