Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2017
    Posts
    1

    How do you sort column that is populated with lookup values

    I am trying to sort the values in column in table. This column is populated by lookup values. (drop-down opens and you choose the names entered) Currently the table does not sort when I select to sort it. What am I missing? What is preventing me from sorting this column? How do I make it sortable. I am using access 2016

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    This is main reason I don't like to set lookups in table, I want to see the actual value that's in the field. The sort is on the actual stored value, not the lookup alias. If you want to sort by the alias text, then must join the two tables so the text field is available.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    In addition to what June7 has stated, you should look at this link to understand why this is a poor practice.

    http://access.mvps.org/access/lookupfields.htm

  4. #4
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Not to mention that users shouldn't be entering data directly into tables.

    We're all assuming the drop down is in the table rather than a form, which is perfectly logical given the information supplied. But I could take it that it's on a form, which means the data is probably numbers stored as text, thus doesn't sort as expected.
    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: 2
    Last Post: 01-20-2016, 08:43 AM
  2. Replies: 14
    Last Post: 07-13-2015, 12:47 PM
  3. Replies: 3
    Last Post: 05-08-2015, 11:08 AM
  4. Table lookup, sort of
    By avarusbrightfyre in forum Programming
    Replies: 1
    Last Post: 08-30-2011, 02:20 PM
  5. Lookup values in one column from another record
    By cjayjones in forum Queries
    Replies: 16
    Last Post: 08-05-2009, 02:27 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