MS Access SQL Script to Calculate Pro-rata Values

$10-30 AUD

Selesai

Dibuat

hampir 6 tahun yang lalu

$10-30 AUD

Dibayar ketika dikirim

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 Proyek: 17372129

Tentang proyek

12 proposal

Proyek remot

Aktif 6 tahun yang lalu

Ingin menghasilkan uang?

Alamat email

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda

Dapatkan bayaran atas pekerjaan Anda

Uraikan proposal Anda

Gratis mendaftar dan menawar pekerjaan

Diberikan kepada:

@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 dalam 1 hari

4,9

(92 ulasan)

5,9

12 freelancer menawar dengan rata-rata $86 AUD untuk pekerjaan ini

@zu02

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

$166 AUD dalam 1 hari

4,6

(44 ulasan)

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 dalam 1 hari

4,8

(10 ulasan)

4,5

@vmadhavan15

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

$150 AUD dalam 1 hari

4,9

(12 ulasan)

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 dalam 5 hari

0,0

(0 ulasan)

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 dalam 3 hari

0,0

(0 ulasan)

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 dalam 1 hari