Create percent rank table for access

Budget $30 - $100 USD
Bids 11
Average Bid $148

I will have an MS Access db containing two tables (tbl_ROE_Analysis_PTD and tbl_ROE_Analysis_LTM). Each structured is structured exactly the same, with ~115 fields and each table contains ~50,000 records.

The table structure for each table is as follows:
- ID
- Period (text)
- Segment (text)
- Variable 1 (number)
- Variable 2 (number)
...
- Variable 112 (number)

I need sometone to:
1. Write me an efficient function/module/query to determine the percentrank (per the excel function) for all records for all variable, where the Segment and Period field is the same as other records in the table, and
2. output the results to new tables (tbl_ROE_Analysis_pct_PTD and tbl_ROE_Analysis_pct_LTM) with the same structure as the original 2 tables.
3. Provide me with the underlying code to run the process separately.

Percentrank is basically dividing the decending rank of the variable n record by the total count of records where the segment & periods field values are the same. Where records have equal value, the percentrank results should be equal.

Given the relatively large dataset, this will require someone who knows what they are doing with efficient coding and is patient enough generate the full results to make the new tables.

In your bid, please let me know how long you believe it will take to execute your code/function/sql.




I will pay $200 for this when its delivered.




Let me know if you need more information to work out if you will take this on.




Regards,

Fergus

Post a Project Like This

This project was awarded to

Hispatronic

I've used several freelancers now and Hispatronic is great. Great communication, really understood what I wanted done and very friendly. End result is exactly what I wanted. Awesome! Will use again.
About the Freelancer
Hispatronic Profile Picture

Freelance del campo de las nuevas tecnologías, respaldado por un pequeño equipo humano de expertos en Programación, Desarrollo Web, Diseño Gráfico e Infografía. Freelance in the Techlonogy Field, backuped by a small human group of experts in Programming, Web Development, Graphic Design and Infographics.

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • emanuelhigh Profile Picture

    emanuelhigh

    JAEN,  Spain

    Bachelor of administrative business and intelligent business I've finished first, I offer solutions in accounting, analysis, management, financial search and marketyng. I have years of experience and courses to improve my professional profile have done several courses in programming and market analysis. I have over 8 years of experience. I offer solution in time shortest possible

    Data Entry, Proofreading, Accounting, and Blog

  • amcsummers Profile Picture

    amcsummers

    Mesa,  United States

    I have spent the last past 19 years working in the Information Services sector. My mission has been to educate myself in all aspects of computer programming. I have been working exclusively with SQL Server 2000-2008, PL/SQL, VB, VBA, Excel, Access, and HTML over the past 12 years. I am currently attending school to complete my web development degree. I am an enthusiastic employee that strives for perfection and enjoy challenging atmospheres.

    Engineering, Electronics, Training, and Accounting

  • sbengul Profile Picture

    sbengul

    Istanbul,  Turkey

    Willing to complete sophisticated projects on time.

    PHP, XML, Visual Basic, and Photography

  • winnet21 Profile Picture

    winnet21

    Tam Ky, QNam,  Vietnam

    Hi all ! I have experience with web app, desktop app, Data Processing, Mobile App... I using delphi,lazarus, php, asp , .net Database : Ms Access , Sql Server, Mysql, Oracle, Paradox... I already have software packaged : 1. Software for repair shop 2. Software for restaurant 3. Software for clock in with rfid 4. POS for gold, diamond, watch, repair, scrap gold 5. Money tranfer database 6. Sales and Inventory Look forward to working with you!! Best regards Winnet

    C Programming, Visual Basic, .NET, and Windows Desktop

  • Prashantskin Profile Picture

    Prashantskin

    Bhavnagar,  India

    Expert in Microsoft Access and Visual Basic and PDA programming Exeperience of 5 years.

    PHP, Visual Basic, Data Processing, and Data Entry

  • srdas2012 Profile Picture

    srdas2012

    chennai,  India

    We are experts in VB.net, VB, VB6, C#, ASP.Net, Visual Foxpro Programming, Back End Access, SQL, MySQL, XML, Excel, CSV with more than 10 Years of experience. We have expertise in Multimedia graphics Programmes for Maya (3d Modelling,Animation), 3d Max ,Z-Brush and Photo shop with more than 10 Years of experience. We have experts & professional translators in Hindi, Bengali, Tamil from & to English. Our motto for every customer/client/project is importance, delivery and maintaining High Quality Standard in the shortest time Possible.

    PHP, ASP, XML, and Visual Basic

  • PerfectSquare Profile Picture

    PerfectSquare

    rawalpindi,  Pakistan

    I am software Engineer master Degree in Computer Science. I have seven years of experience in development and design of database projects. I also have expertise in mathematics and SPSS. I am working as oracle programmer for four years, oracle 9i and oracle 10G Form builder expert. I have also experience in Microsoft technologies. I have 7 years of database development experience.

    Engineering, Excel, UML Design, and Statistics

  • Pharoa Profile Picture

    Pharoa

    Addis Ababa,  Ethiopia

    Customized Business and Software Solutions in education, Business and Hospitality. We develop and support the CampusManager(Tm) Software family or enterprise applications, FinancialWorld(Tm) Software family of applications and InsuranceWorks(Tm) Software. We develop with Visual Studio, Visual FoxPro and Oracle

    PHP, ASP, Java, and XML

  • InSolWorld Profile Picture

    InSolWorld

    Ho Chi Minh City,  Vietnam

    If you need someone who can write Oracle SQL statements or PL-SQL procedures, functions as well as other data processing task, I will make you satisfy with the results with lowest prices when you hire me :) Implementing Java program, Java assignment using Eclipse, Netbeans. Doing university assignment to guarantee high marks :).

    Java, JSP, XML, and Python

  • Hispatronic Profile Picture

    Hispatronic

    Malaga,  Spain

    Freelance del campo de las nuevas tecnologías, respaldado por un pequeño equipo humano de expertos en Programación, Desarrollo Web, Diseño Gráfico e Infografía. Freelance in the Techlonogy Field, backuped by a small human group of experts in Programming, Web Development, Graphic Design and Infographics.

    PHP, Java, Website Design, and Graphic Design