+ Reply to Thread
Results 1 to 2 of 2

adodb sum group by help

  1. #1
    Registered User
    Join Date
    08-03-2011
    Location
    Norwich
    MS-Off Ver
    Excel 2010
    Posts
    28

    adodb sum group by help

    Hi guys

    I am having some issues with the following code. What I am trying to achieve is that for every instance of an agency code it counts where basis is 1 (int in db) and displays the result. So my list box should look like this

    agencyname sumofbasis


    What I am actually getting is an missing object 424 error!

    Please Login or Register  to view this content.
    Can someone point me in the right direction?

    Excel/VBA 2010

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: adodb sum group by help

    I reckon there's a typo here
    Please Login or Register  to view this content.
    as it's dirtyapplist everywhere else. since you've got a with...end with block you may as well use it
    Please Login or Register  to view this content.
    or better yet
    Please Login or Register  to view this content.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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