Address list in a look up field

R

Ron

I have created a look up field that shows all the info of a address for a
company.
But the problem is when I put it in a report it only show the first column.
I would like the rest of the info but I would like to look like a address
label.

Can some one help me.

Ron
 
A

Arvin Meyer

Read my diatribe about the Evils of Lookup fields:

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

You need to build a REAL query. Go into the SQL in the lookup field and copy
it. Start a new query and go into SQL View then paste it. Move to Design
View and add the fields you need, then link that query to your underlying
report query by joining on the lookup field. Now you have all the data and
fields you need for your report.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top