Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 22nd, 2003, 11:13 AM
Authorized User
 
Join Date: Jun 2003
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Selecting data from lookup fields

Hello all,

I'm working producing a set of mailing labels. Access is used to edit/hold the data and Word will be used to do the label merge with the DB as the data source. Here's my problem: I'm having trouble getting the correct data into the merge.

There is a main table with all the relevant address data, but for some reason, the DB was set up with look up fields for the City, State, ZIP, and CompanyName. When I run a simple query to get the info for the labels, the data looks fine in the query window, but when I export or use the query as a data source, I end up with the ID# from each of the smaller tables instead of the City, State, etc...(These tables have an auto-number as the primary key with a description field).

Can someone give me a hand here? I've read through several manuals, but they're not very much help. I appreciate any help I can get. Thank you. -RK
__________________
She stood on the bridge at midnight,
Her lips were all aquiver.
She gave a cough,
Her leg fell off,
and floated down the river.
 
Old September 22nd, 2003, 11:22 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I guess I'm wondering why you don't use Access for printing the labels.

Beth M
 
Old September 22nd, 2003, 11:26 AM
Authorized User
 
Join Date: Jun 2003
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

*Blush* Thank you for not laughing, or at least, not lauging where I could hear you. :-) This certainly is a Monday. Thank you.

-RK
 
Old September 25th, 2003, 11:14 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

No problem. Sometimes the easiest is the all-too-obvious and we overlook it. Kind of like, "I couldn't see the forest for all of the trees"





Similar Threads
Thread Thread Starter Forum Replies Last Post
SELECTING CERTAIN FIELDS IN A DATAGRID??? twyce General .NET 1 November 14th, 2008 02:22 PM
Selecting Data from a table nkrust Javascript 7 January 11th, 2007 05:44 AM
Selecting Fields to be printed on vb6 report marvs Pro VB Databases 0 June 29th, 2005 07:36 PM
Selecting Data.. NitinJoshi General .NET 3 January 18th, 2005 02:59 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.