Address list in a look up field

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

Guest

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
 
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
 
You must log in or register to reply here.

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

create a look up 17
Lookup Fields Show all Info 1
Access Skip address field if previous field is blank 2
Update fields 3
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
Address bar codes on Mailing Labels 1
DLookup and Nz 0
Access Automatically Send a notification email once a record is added 0

Back
Top