Results 1 to 3 of 3
  1. #1
    co14ers is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Nov 2016
    Posts
    1

    Advanced sorting options to use on an Access Report

    I have a SharePoint database built as a phone roster for my organization. I am using access to extract personnel and numbers from that database to create a 1 page list of "quick reference numbers" that we use the most. The problem I have is the factory sort and grouping options within access work well in building a sheet that works, sort of. There are a handful of numbers that I want to have priority over all other sorts so that they are the first to be listed on the page when printed.
    I think in order to achieve this I need to use some kind of macro of script but its outside me level of programing knowledge to build on my own. Does anyone have any ideas that can help me to do this?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    I don't think you need programming, you need another sort field.
    add another table to create different sort groups.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Typically you wouldn't do it with code. How would you identify the numbers? If there's a field in the data you can use, then adding a "sort" field to a query or report is easy.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Access report header and sorting
    By lonely in forum Access
    Replies: 12
    Last Post: 08-20-2015, 12:48 PM
  2. Replies: 14
    Last Post: 11-23-2014, 05:01 PM
  3. Advanced Sort of Report
    By Mpike926 in forum Access
    Replies: 7
    Last Post: 08-29-2012, 11:59 AM
  4. Advanced sorting
    By Adele in forum Queries
    Replies: 3
    Last Post: 08-04-2011, 03:25 PM
  5. Access report with 3 tables -grouping,sorting
    By kartechy in forum Reports
    Replies: 0
    Last Post: 07-22-2009, 09:07 AM

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