makasih pak panduannya akan saya coba terapkan di database saya.
Me.txtSelisihJam = DateDiff("h", #4/25/2011 10:12:00 AM#, #4/27/2011 1:00:00 PM#)
jadi tinggal masukin field nya aja kan pak contoh
Me.txtSelisihJam = DateDiff("h", [jam awal], [jam akhir])
salam
rusman
From: sudarsono [mailto:jkssbma@yahoo.com]
To: belajar-access@yahoogroups.com
Sent: Wed, 27 Apr 2011 01:36:09 +0000
Subject: [belajar-access] Re: tanya jumlah jam
coba :
Me.txtSelisihJam = DateDiff("h", #4/25/2011 10:12:00 AM#, #4/27/2011 1:00:00 PM#)
hasil 51 jam
'====
--- In belajar-access@yahoogroups.com, Rusmanto <rusmanto@...> wrote:
>
> Assalamuallaikum,
>
> Temen-temen boleh minta tolong gimana caranya saya mau mencari jumlah jam tapi beda hari.
>
> contoh
>
> Jam Keluar Jam Datang Total Jam
> 9:00 21/4/2011 8:00 27/4/2011 ....................
>
> nah yang saya mau cari Total jam nya...
>
> terimakasih sebelumnya
>
> wassalam
> Rusman
>
>
>
>
> *** This e-mail and attachments it might contains has passed internal anti-virus check but it is suggested for you to re-scan with your anti-virus ***
>
> Disclaimer Notice :
> This message and any attachment contains information intended only for the use of the addresee named above. It may also be confidential and/or privileged.
> If you are not the intended recipient of this message you are herby notified that you must not disseminate, copy or take any action in reliance on it. Please delete the message and notify the sender.
> Opinions, conclusions and other information in this message that do not relate to the official business of Archipelago Resources Plc., Archipelago Resources Pty Ltd.,
> PT Meares Soputan Mining, PT Tambang Tondano Nusajaya shall be understood as neither given nor endorsed by them.
>
*** This e-mail and attachments it might contains has passed internal anti-virus check but it is suggested for you to re-scan with your anti-virus ***
Disclaimer Notice :
This message and any attachment contains information intended only for the use of the addresee named above. It may also be confidential and/or privileged.
If you are not the intended recipient of this message you are herby notified that you must not disseminate, copy or take any action in reliance on it. Please delete the message and notify the sender.
Opinions, conclusions and other information in this message that do not relate to the official business of Archipelago Resources Plc., Archipelago Resources Pty Ltd.,
PT Meares Soputan Mining, PT Tambang Tondano Nusajaya shall be understood as neither given nor endorsed by them.
__._,_.___
SPAM IS PROHIBITED
Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
__,_._,___
No comments:
Post a Comment