Results 1 to 2 of 2
  1. #1
    Mercator is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2012
    Posts
    10

    Sort "A to Z"/"Z to A" in a Web Datasheet's lookup fields?

    Hi All:



    I have published an Access Web Database to SharePoint. It has a Main Navigation form and two subforms; one for data entry and the other is a web datasheet (to look like Excel per the end-users' request). In the web datasheet on SharePoint, the lookup fields (20 of them) can only be filtered not sorted when a user right-clicks on the field name. However, if the user opens this web database in Access, goes into the web datasheet form, and right-clicks the same lookup fields, the Sort A to Z, Sort Z to A options are there. Any ideas as to why this is the case? Or how to have these sort options available in the web datasheet form? I posted this in the SharePoint forum as this seemed SharePoint specific rather than the Forms forum.

    Thanks.
    Merc

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Google: Sharepoint sort order fields

    Don't know much about Sharepoint but this link indicates 'lists' can be sorted by right click on the column header. http://office.microsoft.com/en-us/wi...001161180.aspx
    Also http://office.microsoft.com/en-us/wi...001161240.aspx

    But not seeing option for descending order.
    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.

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

Similar Threads

  1. Replies: 2
    Last Post: 11-26-2012, 11:12 PM
  2. Replies: 2
    Last Post: 11-14-2012, 04:47 PM
  3. Export "Query or Report" to a "Delimited Text File"
    By hawzmolly in forum Import/Export Data
    Replies: 3
    Last Post: 08-31-2012, 08:00 AM
  4. Replies: 11
    Last Post: 03-29-2012, 02:32 PM
  5. Replies: 16
    Last Post: 07-22-2011, 09:23 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