MS Access SQL Script to Calculate Pro-rata Values

$10-30 AUD

Concluído

Publicado

há quase 6 anos

$10-30 AUD

Pago na entrega

For a given database with start dates, end dates, and values, I would like a query which calculates (pro-rates) this into different calendar months. Refer to attached sample Excel - the yellow highlight mimics the database. The output (query) should come from a query compatible with MS Access (SQL) and be a timespan of the rest of the 2018 calendar year.

Microsoft Access

SQL

ID do Projeto: 17372129

Sobre o projeto

12 propostas

Projeto remoto

Ativo há 6 anos

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo

Seja pago pelo seu trabalho

Descreva sua proposta

É grátis para se inscrever e fazer ofertas em trabalhos

Concedido a:

@VladimirLilenko

It's Excel or Access project? I can write SQL querry for you in Access DB. Relevant Skills and Experience Microsoft Access, SQL Proposed Milestones $30 AUD - Project completed

$30 AUD em 1 dia

4,9

(92 avaliações)

5,9

12 freelancers estão ofertando em média $86 AUD for esse trabalho

@zu02

I'll code this today and for 150 aud Relevant Skills and Experience vba/sql/ado Proposed Milestones $166 AUD - default

$166 AUD em 1 dia

4,6

(44 avaliações)

6,1

@SergioAlfaroV

I would require only access to your Access database. I can write your query in two hours, tops. Relevant Skills and Experience SQL: Advanced English: Near-native Proposed Milestones $30 AUD - Query working.

$30 AUD em 1 dia

4,8

(10 avaliações)

4,5

@vmadhavan15

am not a random bidder... Relevant Skills and Experience VBA Proposed Milestones $150 AUD - final

$150 AUD em 1 dia

4,9

(12 avaliações)

4,2

@lazygeek2k18

Hi I have read the description and the project is doable. Relevant Skills and Experience I have work on multiple projects where i implemented databases. Proposed Milestones $50 AUD - All the requirements will be fulfilled.

$50 AUD em 5 dias

0,0

(0 avaliações)

0,0

@extasee

HIGHLY interested with your project. I'm ready to start right now. I'm an individual developer and my completion rate is always 100%. I STRICTLY BITE only WHICH I CAN CHEW. Knock me please

$150 AUD em 3 dias

0,0

(0 avaliações)

0,0

@rairado

Experienced Software Developer, knowledgeable Information Technology and Networking professional seeking to contribute with acquired skills within computer field. Relevant Skills and Experience Experienced Software Developer, knowledgeable Information Technology and Networking professional seeking to contribute with acquired skills within computer field. Proposed Milestones $260 AUD - If I describe the steps and ways to do the task, I will not have to do it, ok?

$222 AUD em 1 dia