Create percent rank table for access

IN PROGRESS
Bids
11
Avg Bid (USD)
$148
Project Budget (USD)
$30 - $100

Project Description:
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

Skills required:
Microsoft Access, SQL, Visual Basic
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 100
in 3 days
$ 200
in 5 days
Hire amcsummers
$ 100
in 3 days
Hire Pharoa
$ 200
in 3 days
$ 192
in 1 days
$ 182
in 4 days
$ 100
in 2 days
Hire emanuelhigh
$ 150
in 1 days
$ 110
in 7 days
Hire sbengul
$ 100
in 3 days