SQL query for Microsoft Access

$30-250 USD

Finalizat

Data postării:

peste 5 ani în urmă

$30-250 USD

Plata la predare

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-ul proiectului: 18205949

Despre proiect

9 propuneri

Proiect la distanță

Activ: 5 ani în urmă

Vrei să câștigi bani?

Adresa de e-mail

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal

Îți primești plata pentru serviciile prestate

Evidențiază-ți propunerea

Te înregistrezi și licitezi gratuit pentru proiecte

Acordat utilizatorului:

@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 în 2 zile

4,8

(168 recenzii)

6,3

9 freelanceri plasează o ofertă medie de $170 USD pentru proiect

@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 în 5 zile

4,9

(52 recenzii)

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 în 2 zile

4,9

(199 recenzii)

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 în 3 zile

5,0

(3 recenzii)

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 în 3 zile

4,8

(9 recenzii)

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 în 3 zile