MS Access SQL Script to Calculate Pro-rata Values

$10-30 AUD

Completed

Posted

almost 6 years ago

$10-30 AUD

Paid on delivery

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

Project ID: 17372129

About the project

12 proposals

Remote project

Active 6 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:

@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 in 1 day

4.9

(92 reviews)

5.9

12 freelancers are bidding on average $86 AUD for this job

@zu02

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

$166 AUD in 1 day

4.6

(44 reviews)

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 in 1 day

4.8

(10 reviews)

4.5

@vmadhavan15

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

$150 AUD in 1 day

4.9

(12 reviews)

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

0.0

(0 reviews)

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

0.0

(0 reviews)

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 in 1 day