Only ID numbers are printing

V

Vanessa

I have Access 2007. I have two tables Contact List and Asset List. I am
trying to print two reports. I want to print the owner and the companies
they lease to from the Asset List. Also from the Contact List I would like
to list the Companies and their Lessors. When I try to do the asset list one
it only gives me id numbers. What am I doing wrong?
 
D

Duane Hookom

This is a typical issue when you use lookup fields in tables. My advice is:
don't use them.

Your report's record source must contain the field that actually stores the
value you would like to display 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

SQL query with join on substring 5
Charting Missing data accross three related tables by region and % 1
Unable to bring back all results from table with query 1
Users and Asset Data linked on Form 4
How to construct a hierarchy from a list? (Access 2003) 4
Form creates unwanted rows in table 1
Using 2 Queries for One Report 1
Vlookup and IIF Functions, etc 3

Top