Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Pontiac, Michigan, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DataAccessPage GroupLevel DefaultSort (XP)

    I've managed to create a DAP that works. However, I want the Main Group Level to sort alphabetically (rather than customer number as it stands now). How do I accomplish this?

    What little help I've found in Access and my books say to type " ASC" (note the space preceding the ASC) in the DefaultSort property field. But that doesn't work.

    TIA.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DataAccessPage GroupLevel DefaultSort (XP)

    Enter the name of the field on which you want to sort in the DefaultSort property.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: DataAccessPage GroupLevel DefaultSort (XP)

    You don't really need to add ASC - sorting ascending is the default. If you want to sort descending, add a space and DESC after the field name.

  4. #4
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Pontiac, Michigan, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DataAccessPage GroupLevel DefaultSort (XP)

    Oh, okay. Thanks. When I was wandering through the help, it said to use ASC or DESC and when I had my eureka moment (by looking at a DAP created with a wizard) I saw that the ASC was there.

    I did enter the fieldname properly surrounded by brackets. I'll edit my original posting so no one else gets tripped up.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2004
    Location
    Pontiac, Michigan, USA
    Posts
    170
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DataAccessPage GroupLevel DefaultSort (XP)

    Ah HA! <img src=/S/doh.gif border=0 alt=doh width=15 height=15> ! If you don't put in a fieldname, nothing works. Here's how it should be entered: [fieldname] ASC, Note the space between the fieldname and ASC and the ending comma. This does work.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •