MS Access SQL Script to Calculate Pro-rata Values

$10-30 AUD

Suoritettu

Julkaistu

lähes 6 vuotta sitten

$10-30 AUD

Maksettu toimituksen yhteydessä

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

Projektin tunnus (ID): 17372129

Tietoa projektista

12 ehdotukset

Etäprojekti

Aktiivinen 6 vuotta sitten

Haluatko ansaita rahaa?

Sähköpostiosoite

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu

Saa maksu työstäsi

Kuvaile ehdotustasi

Rekisteröinti ja töihin tarjoaminen on ilmaista

Myönnetty käyttäjälle:

@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 1 päivässä

4,9

(92 arvostelua)

5,9

12 freelancerit tarjoavat keskimäärin $86 AUD tätä projektia

@zu02

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

$166 AUD 1 päivässä

4,6

(44 arvostelua)

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 1 päivässä

4,8

(10 arvostelua)

4,5

@vmadhavan15

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

$150 AUD 1 päivässä

4,9

(12 arvostelua)

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 5 päivässä

0,0

(0 arvostelua)

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 3 päivässä

0,0

(0 arvostelua)

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 1 päivässä