Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    New England (Connecticut)
    Posts
    200
    Thanks
    1
    Thanked 0 Times in 0 Posts

    report grouping Access 2007

    I am trying to group records in a report that need to be grouped on a record ID that contains "-" in the ID... to elaborate a record ID contains some numbers and letters followed by a "-" and then more numbers and letters... I need to group on everything after the "-" but the record ID contains different string lengths before and after the "-"... I am at a loss on how to do this since I don't know how to look for the "-" in the string and then group on the part of the string that follows... can anyone point me in the right direction... I have tried various combinations of the mid$, left$ and Right$ functions but cannot pin this down so that it works


    thank you
    Last edited by mcneilkm; 2014-10-08 at 14:20.
    Kevin

  2. #2
    WS Lounge VIP Browni's Avatar
    Join Date
    Dec 2009
    Location
    Rochdale, UK
    Posts
    1,651
    Thanks
    38
    Thanked 161 Times in 139 Posts
    InStr is what you are looking for. Once you know the location you can then use the other functions you refer to.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    New England (Connecticut)
    Posts
    200
    Thanks
    1
    Thanked 0 Times in 0 Posts
    thank you, that worked perfect
    Kevin

Posting Permissions

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