Pake datediff dah dicoba?
Kalau ente punya
Expr2: now()-[expr1]
Coba diubah jadi
Expr2: DateDiff("d",[Expr1],Now())
_____
From: [email protected] [mailto:[email protected]]
On Behalf Of [email protected]
Sent: Tuesday, 7 April, 2009 2:36 PM
To: [email protected]
Cc: [email protected]
Subject: Re: [belajar-access] Pembulatan hasil
Sorry, maksud saya : Saya pikir kalau pengurangan tanggal selalu bulat
karena tanggal tidak pernah pecahan.
[email protected]
Sent by: [email protected]
04/07/2009 01:28 PM
Please respond to belajar-access
To: [email protected]
cc: [email protected]
Subject: Re: [belajar-access] Pembulatan hasil
Coba di query di text boxnya formatnya fixed dan decimal placesnya 0.
planner_grnt <[email protected]>
Sent by: [email protected]
04/07/2009 01:16 PM
Please respond to belajar-access
To: [email protected]
cc:
Subject: Re: [belajar-access] Pembulatan hasil
ma`af rekan saya agak tergagap2 nich,
saya coba sperti ini tapi gak seperti yg saya maksud ya, mohon lagi
pencerahannya ya..
salam
herman
[email protected] wrote:
Saya coba menjawab. Di query click kanan di field yang dituju dan ganti
formatnya..spt. angka decimalnya.
regard,
Tio
planner_grnt <[email protected]>
Sent by: [email protected]
04/07/2009 08:16 AM
Please respond to belajar-access
To: [email protected]
cc:
Subject: [belajar-access] Pembulatan hasil
Yth, milister belajar acces,
cara pembulatan hasil pengurangan dg type tanggal baagimana ya..?
misal : ([Tgl sekarang] )-([tgl jatuh tempo]), sy ingin hasilnya angka
pembulatan misalnya = 30
saya coba di query banya anka desimalnya, mohon pencerahan dari rekan-rekan
,
terimakasih sebelumnya.
Salam
herman
===========================================================================
This email is confidential. If you are not the addressee tell the sender
immediately and destroy this email without using, sending or storing it.
Emails are not secure and may suffer errors, viruses, delay, interception
and amendment. The Trakindo Group of Companies do not accept liability for
damage caused by this email and may monitor email traffic.
Unless expressly stated, any opinions are the sender's and are not approved
by the Tiara Marga Trakindo Group of Companies and this email is not an
offer, solicitation, recommendation or agreement of any kind.
===========================================================================
===========================================================================
This email is confidential. If you are not the addressee tell the sender
immediately and destroy this email without using, sending or storing it.
Emails are not secure and may suffer errors, viruses, delay, interception
and amendment. The Trakindo Group of Companies do not accept liability for
damage caused by this email and may monitor email traffic.
Unless expressly stated, any opinions are the sender's and are not approved
by the Tiara Marga Trakindo Group of Companies and this email is not an
offer, solicitation, recommendation or agreement of any kind.
===========================================================================
===========================================================================
This email is confidential. If you are not the addressee tell the sender
immediately and destroy this email without using, sending or storing it.
Emails are not secure and may suffer errors, viruses, delay, interception
and amendment. The Trakindo Group of Companies do not accept liability for
damage caused by this email and may monitor email traffic.
Unless expressly stated, any opinions are the sender's and are not approved
by the Tiara Marga Trakindo Group of Companies and this email is not an
offer, solicitation, recommendation or agreement of any kind.
===========================================================================
<<image001.gif>>
