Mas Hari,
Tidak bisa diconvert ke 2003, saya menggunakan access 2010, mohon pencerhannya
regards
From: belajar-access@yahoogroups.com [mailto:belajar-access@yahoogroups.com] On Behalf Of hari yanto
Sent: Monday, April 21, 2014 7:18 PM
To: belajar-access@yahoogroups.com
Subject: RE: [belajar-access] NEwbie mau Split Monthly
Yasman.David...,
Coba lampirannya diubah ke mdb 2003, ya.... Soalnya di lap top saya masih kuno.
--------------------------------------------
On Mon, 21/4/14, David, Yasman (ECM - RIAU) <Yasman.David@rekindworleyparsons.com> wrote:
Subject: RE: [belajar-access] NEwbie mau Split Monthly
To: belajar-access@yahoogroups.com
Date: Monday, 21 April, 2014, 2:51 PM
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."
*** 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 (5) |
Tidak ada komentar:
Posting Komentar