+ Reply to Thread
Results 1 to 3 of 3

Sort recordset results

  1. #1
    Registered User
    Join Date
    09-28-2015
    Location
    RI, USA
    MS-Off Ver
    2010
    Posts
    42

    Sort recordset results

    Is there an easy way to sort the results of the addresses found in the following code for a customer name that has multiple addresses.

    I have tried working with .sort, but either am putting it in the wrong place or using it wrong as I cannot get it to sort the results of the list.

    Please Login or Register  to view this content.
    Also this code finds unique customer names and removes duplicates. How difficult to get the same function on addresses. Some of our accounts have multiple records at the same address. The only difference is the related customer number for that address which would be part of that recordsset.

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,517

    Re: Sort recordset results

    Like this, see highlighted text below.

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Registered User
    Join Date
    09-28-2015
    Location
    RI, USA
    MS-Off Ver
    2010
    Posts
    42

    Re: Sort recordset results

    Thanks. You are the best

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sort Rows and copy sort results to new worksheet?
    By Apache_sim in forum Excel General
    Replies: 0
    Last Post: 06-30-2015, 03:17 AM
  2. Sort Query Results to remove duplicate entries and put results on one line.
    By Panther70 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-01-2015, 03:03 PM
  3. Replies: 4
    Last Post: 11-20-2012, 06:00 PM
  4. SQL Query to Count Results in Recordset
    By kortex in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2012, 09:51 AM
  5. [SOLVED] sql stored procedure results in a recordset questions
    By in-over-his-head-bill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2006, 01:40 PM
  6. Querytable results into vba Recordset
    By Aaron in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2005, 06:18 AM
  7. [SOLVED] [SOLVED] Web query results in a recordset?
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2005, 06:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1