Results 1 to 4 of 4
  1. #1
    fish001 is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    8

    Show text value instead of ID

    Hi All,



    I have a table with multiple field that shows ID.

    How do i show another field value instead of the ID in queries?

    Please helppppp.

    Many Thanks.

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Just select the field(s) you want in the query designer.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    Join Date
    Apr 2017
    Posts
    1,673
    Quote Originally Posted by ridders52 View Post
    Just select the field(s) you want in the query designer.
    I'm afraid OP is not by JOIN yet!
    When the results where only rows with YourSecondTableText determined are returned are wanted:
    Code:
    SELECT  t1.YourFirstTablePK, t2.YourSecondTableText ROM tblYourFirstTable t1 INNER JOIN tblYourSecondTable t2 ON t2.YourSecondTablePK =t1.YourFirstTableFK
    When all records from YourFirstTable must be returned, with Null as YourSecondTableText when no match exists, or when FK in YourFirstTable is empty:
    Code:
    SELECT  t1.YourFirstTablePK, t2.YourSecondTableText ROM tblYourFirstTable t1 LEFT JOIN tblYourSecondTable t2 ON t2.YourSecondTablePK =t1.YourFirstTableFK

  4. #4
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I have a table with multiple field that shows ID.
    I interpret this to mean that the field is a multi value field. If that is the case, I think the issue is an entirely different matter than what has been addressed.
    @fish001; is it a multi value field you are querying?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 02-24-2016, 10:58 PM
  2. Getting text to show
    By ortizgabe in forum Reports
    Replies: 4
    Last Post: 06-26-2014, 04:03 PM
  3. Hide Show Text Box
    By Derrick T. Davidson in forum Forms
    Replies: 3
    Last Post: 04-09-2013, 11:13 PM
  4. Replies: 3
    Last Post: 12-22-2012, 05:33 PM
  5. Text Box to show specific record
    By chu3w in forum Forms
    Replies: 1
    Last Post: 04-01-2010, 12:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums