tgl2 = #5/1/2011# '01 Mei 2011
jangkauanhr = DateDiff("d", tgl1, tgl2)
jangkauanbl = DateDiff("m", tgl1, tgl2)
jangkauanth = DateDiff("yyyy", tgl1, tgl2)
'====
--- In belajar-access@yahoogroups.com, "Ahmad Ghozali, SH" <a_ghozalish@...> wrote:
>
> Semoga para master access tidak bosan ya dengan pertanyaan-2 saya, hehehe
>
> Apakah di access ada fungsi untuk menerapkan fungsi matematik dll
> sebagaimana di excel ?
> JIka ya, di mana saya bisa menerapkannya ?
>
> contoh kasusnya sbb :
> A masuk kerja tgl 1 jan 2000
> bagaimana formulasi untuk menghitung masa kerja si A sampai dengan tgl 1
> Mei 2011 ?
>
> tks
>
> salam
> Ghozali
>
------------------------------------
SPAM IS PROHIBITEDYahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)
<*> To change settings via email:
belajar-access-digest@yahoogroups.com
belajar-access-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
No comments:
Post a Comment