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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|