Find Jobs
Hire Freelancers

Create percent rank table for access

$30-100 USD

Terminado
Publicado hace casi 11 años

$30-100 USD

Pagado a la entrega
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
ID del proyecto: 4400126

Información sobre el proyecto

11 propuestas
Proyecto remoto
Activo hace 11 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi. I'm a Computers Ingeneer with long experience in Access programming and Data Mining. I think I can help you with this projects. PM sent for more details. Thanks.
$110 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
11 freelancers están ofertando un promedio de $148 USD por este trabajo
Avatar del usuario
Hi, I have experience with this project, I happily if work with you in this project. Best Regards
$200 USD en 5 días
4,8 (20 comentarios)
5,2
5,2
Avatar del usuario
Wow that is a lot of fields. I would probably do this in VBA module since there is so many fields and the fields are Variable 1-112. It would be easier to put it in a loop. When you say percent rank for all records are we adding Variable 1-112 or doing each variable independently? I am between jobs so I would be able to start today and most likely have it completed in 3-4 days. For the past 15 years I have worked with Excel/MS Access and 11 years with MS SQL Server 7.0 and 2005. I have been doing my contracting work with VWorker/Freelancer for the past 3 years; during that time I have completed 70 projects ranging from Excel/Access VBA to SQL Server database constructions. In my experiences over the past 3 years I know how daunting it is to try and describe what you are wanting along with sifting through numerous bids. As you can see from my reviews I strive to make sure my customers are happy with my services. I take a lot of pride in my work and stand behind anything I create so if you ever encounter a problem just email me Please feel free to ask any questions I am always willing to share my experience. Best of luck with your search. Michael p.s. I am based in Phoenix AZ, PST, in case you would like to call and discuss.
$100 USD en 3 días
5,0 (43 comentarios)
5,1
5,1
Avatar del usuario
I have over 19 years experience as a database developer along with Strong Excel skills. If awarded, I will deliver in three days from the date of acceptance of my bid.
$200 USD en 3 días
5,0 (2 comentarios)
3,8
3,8
Avatar del usuario
Hi I am professional programmer in MS ACCESS and excel and I know how to do this, I have already used this function in excel So can create query for you in MS ACCESS Just start and get it done Thanks
$192 USD en 1 día
4,5 (22 comentarios)
3,9
3,9
Avatar del usuario
Hi,We are Expert in Access ,We would like to to this,Please see PMB
$182 USD en 4 días
5,0 (10 comentarios)
3,3
3,3
Avatar del usuario
Hi, I have experienced in SQL queries. I strongly believe that I can work well on this project and delivery your expected result. Thanks.
$100 USD en 2 días
5,0 (3 comentarios)
2,0
2,0
Avatar del usuario
Hello! I work as a database developer and I create daily packages to fix/update/modify databases with hundreds of tables. I can do this for you fast and accurate.
$198 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I want to do this project. Thanks in advance.
$100 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Please send some existing data and files so that I can show you a demo
$150 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
New York, United States
5,0
2
Forma de pago verificada
Miembro desde jun 26, 2012

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.