/* */

Thursday, May 5, 2011

[belajar-access] Re: bagaimana menerapkan rumus perhitungan di access 2007 ?

tgl1 = #1/1/2000# '01 januari 200
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