SQL query for Microsoft Access

$30-250 USD

完了済み

投稿日:

5年以上前

$30-250 USD

完了時にお支払い

We need help writing an SQL query for Microsoft access. The calculation that I would like to perform is on time series data. The query selects data from the table (see attached file) related to a single unique identifier (CUSIP) and then performs a rolling calculation for the Variables PosShare , Cost, MV and G_L (see example calculations in attached file). We need to be a able to select different CUSIPS and then rerun query. We would will need to tweak the final code to change outputted values occasionally.

Database Administration

プロジェクト ID: 18205949

プロジェクトについて

9個の提案

リモートプロジェクト

アクティブ 5年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

アワード者:

@mail2vimalarora

Hello, I am ready to discuss project with you. Being experienced in working on several SQL queries and MS Access, I can help you in writing query that you need to get data as shown in output sheet in attached excel based on data_table. I am available to start now and want to discuss more specific details. Looking forward to have further project discussion on chat. Thanks. Vimal Arora

$133 USD 2日以内

4.8

(168 レビュー)

6.3

この仕事に9人のフリーランサーが、平均$170 USDで入札しています

@feninsoftech

Hi, If this query is for SQL Server we can do it by self-joining same table. I have 9 years experience in development and deployment that includes SQL Server, SSRS, SSIS and .NET. Involved in SQL Server activities like Installing, Migrations, Table Partitioning, Configuring maintenance jobs, Optimizing etc. I have expertise in writing complex queries with proper joins and index selection. Involved in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. Thanks

$235 USD 5日以内

4.9

(52 レビュー)

6.9

@VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!

$150 USD 2日以内

4.9

(199 レビュー)

6.9

@ITPyramid85

hello,how are you. i read your bid carefully. i am C#, VB.Net, SqlServer expert and have full experience for 7 years. C#, VB.Net, SqlServer is my top skill and i can complete your project by using that skills. I can provide most quality and high fast. if you want to success, please contact me. Then, I will give you good result. hire me.

$155 USD 3日以内

5.0

(3 レビュー)

4.7

@gr8tech

Hello there I have knowledge of MS Access, where I have created Queries, Forms, Reports and So on. I am available to help you create the required SQL queries in Access to come up with the desired results. I will provide the ability to select different CUSIPs and get the different results for the CUSIPs. I have seen the sample Excel sheet and I would like to discuss with you on the ultimate objective, so that we can automate as much of it as possible I look forward to your response. Moosa

$250 USD 3日以内

4.8

(9 レビュー)

4.3

@priyas171

Hi, Greetings!! We have huge experience of making SQL queries for Microsoft Access. Please chat with us so that we can discuss further Looking forward to your response Thanks & Regards, Sanjana

$277 USD 3日以内