Help with Ranking SQL/VBA/Macros/Modules

Discussion in 'Webmaster / Programming' started by TCB, Dec 17, 2010.

  1. TCB

    TCB

    Joined:
    Dec 17, 2010
    Messages:
    2
    Likes Received:
    0
    I’m looking for help on being able to speed up my Ranking query. Below are a couple of my Rank formulas. And way below is what I copied from access sql.

    How would I clean it up so my query will run faster?

    How would I make this a actually sql statement, so that it will run faster?



    Or should I look at doing a macro or modules?



    I have also attached the database that uses these queries to help better understand what I'm trying to do. Please look at query titled:” qryRank_and_WeightedRank”



    If anyone has any advice help or recommendations, please don’t hesitant to tell me. I'm still new and learning and any time I get help or advice it helps me learn.



    Code:
    3MonthRank: (Select count(*) from GP1_Master_Table_Count_Apps as B where[/size][/font]
      
      [font=Times New Roman][size=3]GP1_Master_Table_Count_Apps.[3Month_App_Count] > B.[3Month_App_Count])




    Code:
    6MonthRank: (Select count(*) from GP1_Master_Table_Count_Apps as B where GP1_Master_Table_Count_Apps.[6Month_App_Count] > B.[6Month_App_Count])




    Code:
    9MonthRank: (Select count(*) from GP1_Master_Table_Count_Apps as B where GP1_Master_Table_Count_Apps.[9Month_App_Count] > B.[9Month_App_Count])








    ;



    Thank you for taking helping me with this question
     

    Attached Files:

    TCB, Dec 17, 2010
    #1
    1. Advertisements

  2. TCB

    V_R @120Hz Moderator

    Joined:
    Jan 31, 2005
    Messages:
    10,527
    Likes Received:
    14
    Location:
    127.0.0.1
    That last code box, i changed to quote as it totally messed up the forums layout..
     
    V_R, Dec 18, 2010
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. rterte

    teratermpro macros

    rterte, May 9, 2006, in forum: Webmaster / Programming
    Replies:
    0
    Views:
    771
    rterte
    May 9, 2006
  2. octane

    Checking your google ranking

    octane, Oct 21, 2009, in forum: Webmaster / Programming
    Replies:
    1
    Views:
    768
  3. vbaCoderMonkey

    Vba to query SQL Plus

    vbaCoderMonkey, Jan 26, 2010, in forum: Webmaster / Programming
    Replies:
    0
    Views:
    1,759
    vbaCoderMonkey
    Jan 26, 2010
  4. spadge

    macros

    spadge, Dec 6, 2011, in forum: Webmaster / Programming
    Replies:
    0
    Views:
    696
    spadge
    Dec 6, 2011
  5. newuser123

    Class Modules

    newuser123, Jan 2, 2013, in forum: Webmaster / Programming
    Replies:
    4
    Views:
    1,304
Loading...

Share This Page