Mas Hariyanto,
Saya coba utak atik yang dimaksud dibawah ini, ternyata saya belum bisa menggunakannya (maklum newbie), mohon petunjuknya lebih dalam, dan memakainya di file terlampir.
rgds
From: belajar-access@yahoogroups.com [mailto:belajar-access@yahoogroups.com] On Behalf Of hari yanto
Sent: Friday, April 11, 2014 10:31 PM
To: belajar-access@yahoogroups.com
Subject: Re: [belajar-access] NEwbie mau Split Monthly
David...,
Untuk menentukan selisih hari gunakan datediff:
Dim LValue As Integer
LValue = DateDiff ("d", #15/10/2003#, #22/11/2003#)
Tanggal awalnya, bisa memakai dmin. Sedangkan maksimalnya dmax.
Untuk menggabungkan dengan yang aktual tentu masing-masing field harus diisi dengan nilai aktualnya. Mengingat masing-masing record memiliki plan dan actual harga.
Semoga bisa membantu dan memberi semangat.
--------------------------------------------
On Fri, 11/4/14, David, Yasman (ECM - RIAU) <Yasman.David@rekindworleyparsons.com> wrote:
Subject: [belajar-access] NEwbie mau Split Monthly
To: belajar-access@yahoogroups.com
Date: Friday, 11 April, 2014, 10:00 AM
Master
Access Saya
Newbie di Access, semoga master selalu dalam keadaan sehat.
AminSaya punya masalah dengan access untuk split
data 1.
Plan BOQ ke
monthly berdasarkan
jumlah hari yang terlibat dalam bulan plan, misal ID 1 Start
3 March 2014 – 9 Juli 2014, berarti di bulan
Maret terlibat 29 hari, maka valuenya di bulan March 2014 =
29/129 * 1550 = $348, 996
2.
Actual BOQ to
Monthly Di Bulan March 2014 ID 1 = $ 25, Di bulan
April 2014 ID 1 = $33
Terima Kasih atas bantuannya.
Regards
***
WORLEYPARSONS GROUP NOTICE ***
"This email is confidential. If you are not the
intended recipient, you must not disclose or use the
information contained in it.
If you have received this email in error, please notify us
immediately by return email and delete the email and any
attachments.
Any personal views or opinions expressed by the writer may
not
necessarily reflect the views or opinions of any company in
the WorleyParsons Group of Companies."
*** WORLEYPARSONS GROUP NOTICE *** "This email is confidential. If you are not the intended recipient, you must not disclose or use the information contained in it. If you have received this email in error, please notify us immediately by return email and delete the email and any attachments. Any personal views or opinions expressed by the writer may not necessarily reflect the views or opinions of any company in the WorleyParsons Group of Companies."
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic () |
Tidak ada komentar:
Posting Komentar