SQL query for Microsoft Access

$30-250 USD

Completed

Posted

over 5 years ago

$30-250 USD

Paid on delivery

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

Project ID: 18205949

About the project

9 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 in 2 days

4.8

(168 reviews)

6.3

9 freelancers are bidding on average $170 USD for this job

@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 in 5 days

4.9

(52 reviews)

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 in 2 days

4.9

(199 reviews)

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 in 3 days

5.0

(3 reviews)

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 in 3 days

4.8

(9 reviews)

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 in 3 days