Master Access
Saya Newbie di Access, semoga master selalu dalam keadaan sehat. Amin
Saya 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."
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic () |
SPAM IS PROHIBITED
.
__,_._,___
Tidak ada komentar:
Posting Komentar