Results 1 to 3 of 3
  1. #1
    ChuckMartin is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2017
    Location
    Sacramento
    Posts
    2

    phone list sorting group by first character.

    I have old access programs the would sort a phone list and group people by last name, first name and separate each group with the first character.
    eg...
    A
    Adams, John
    Apple, joe

    B
    Barron, Steve
    Boyd, Tom

    Since I migrated to Access 2013 these no longer work.


    So I know I am doing something wrong.

    Any help would be appreciated.
    Chuck

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    in the query, make an extra field: Char1: left(lastname,1)
    in the report, sort on this field first, and add the CHAR1 textbox at the top of the group,
    then the Name field in the next sort band.

  3. #3
    ChuckMartin is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2017
    Location
    Sacramento
    Posts
    2

    Smile Perfect Thanks

    Quote Originally Posted by ranman256 View Post
    in the query, make an extra field: Char1: left(lastname,1)
    in the report, sort on this field first, and add the CHAR1 textbox at the top of the group,
    then the Name field in the next sort band.
    Perfect Thanks Chuck

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

Similar Threads

  1. Customer Phone List Example form
    By pkstormy in forum Code Repository
    Replies: 2
    Last Post: 05-06-2017, 03:06 PM
  2. Sorting on group sum
    By gradygoose in forum Reports
    Replies: 1
    Last Post: 02-28-2016, 06:57 PM
  3. Phone List issue
    By Alfi54 in forum Forms
    Replies: 8
    Last Post: 04-17-2012, 09:47 AM
  4. Replies: 10
    Last Post: 12-21-2010, 12:41 PM
  5. Format phone number in an unbound list box
    By kbremner in forum Forms
    Replies: 2
    Last Post: 11-08-2010, 05:11 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