|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 14th, 2007, 05:02 PM
posted to microsoft.public.access.queries
|
|||
|
|||
How do I get the numeric data from a look-up to show as text?
In my query, I have a field (Vendor) that pulls data from a look-up table.
When I run the query, I only get the vendor # and not the vendor name. How do I get the vendor name to show? 
|
|
#2
February 14th, 2007, 05:17 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
How do I get the numeric data from a look-up to show as text?
Add the vendor table to the query and join the Vendor field in your
table to vendor_id in the vendor table and add the vendor_name field in the vendor table to your query. Oh and don't use lookup fields. http://www.mvps.org/access/lookupfields.htm Cheers, Jason Lepack On Feb 14, 12:02 pm, mh7800 wrote: In my query, I have a field (Vendor) that pulls data from a look-up table. When I run the query, I only get the vendor # and not the vendor name. How do I get the vendor name to show?
|
|
#3
February 14th, 2007, 05:56 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
How do I get the numeric data from a look-up to show as text?
Thanks for the help.
"Jason Lepack" wrote: Add the vendor table to the query and join the Vendor field in your table to vendor_id in the vendor table and add the vendor_name field in the vendor table to your query. Oh and don't use lookup fields. http://www.mvps.org/access/lookupfields.htm Cheers, Jason Lepack On Feb 14, 12:02 pm, mh7800 wrote: In my query, I have a field (Vendor) that pulls data from a look-up table. When I run the query, I only get the vendor # and not the vendor name. How do I get the vendor name to show?
|
|
#4
February 14th, 2007, 06:01 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
How do I get the numeric data from a look-up to show as text?
You're welcome.
On Feb 14, 12:56 pm, mh7800 wrote: Thanks for the help. "Jason Lepack" wrote: Add the vendor table to the query and join the Vendor field in your table to vendor_id in the vendor table and add the vendor_name field in the vendor table to your query. Oh and don't use lookup fields. http://www.mvps.org/access/lookupfields.htm Cheers, Jason Lepack On Feb 14, 12:02 pm, mh7800 wrote: In my query, I have a field (Vendor) that pulls data from a look-up table. When I run the query, I only get the vendor # and not the vendor name. How do I get the vendor name to show?- Hide quoted text - - Show quoted text -
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
