Create percent rank table for access

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.



Beceriler: Microsoft Access, SQL, Visual Basic

Daha fazlasını gör: percent rank access, percentrank access, sql rank total access, access percent rank, create percent rank table access, percentrank function access sql, access sql percent rank, what is sql coding, let me write it for you, ms access sql, query table, ms access 2013, fergus, create 200, bid rank, coding visual basic excel, visual basic excel coding, excel access table, access query table, access query excel, run access function sql, basic excel coding, 2013 excel visual basic, excel sql query, excel sql create

İşveren Hakkında:
( 2 değerlendirme ) New York, United States

Proje NO: #4400126



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.

%selectedBids___i_period_sub_7% gün içinde 110%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(0 Değerlendirme)

Bu iş için 11 freelancer ortalamada $148 teklif veriyor


[url removed, login to view] I have gone through your requirements of percentrank function in access and its implementation for various variables into new tables. Please send some existing data and files so that I can show you a dem Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(481 Değerlendirme)

Hi, I have experience with this project, I happily if work with you in this project. Best Regards

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(20 Değerlendirme)

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 Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(43 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(22 Değerlendirme)

Hi,We are Expert in Access ,We would like to to this,Please see PMB

in %bids___i_period_sub_35% gün içinde182%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)

Hi, I have experienced in SQL queries. I strongly believe that I can work well on this project and delivery your expected result. Thanks.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde198%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I want to do this project. Thanks in advance.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Please send some existing data and files so that I can show you a demo

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)