Pada event on lost focus textbox harga, ketikan code:
If isnull(me.harga) then
Me.harga.value = 0
End if
Powered by Telkomsel BlackBerry®
From: "Bambang Hartoko bambanghartoko@yahoo.com [belajar-access]" <belajar-access@yahoogroups.com>
Sender: belajar-access@yahoogroups.com
Date: Wed, 16 Jul 2014 09:07:17 -0700
To: <belajar-access@yahoogroups.com>
ReplyTo: belajar-access@yahoogroups.com
Subject: Re: [belajar-access] Rubah Null jadi 0
khusus untuk access saja, gunakan perintah Nz(variable, jika null diganti dengan apa)
contoh Nz(harga, 0) artinya jika harga bernilai null, maka akan dianggap 0.
Bambang Hartoko
On Wednesday, July 16, 2014 9:53 PM, "dedy heru susanto d3dy_h3rus@yahoo.com [belajar-access]" <belajar-access@yahoogroups.com> wrote:
[Attachment(s) from dedy heru susanto d3dy_h3rus@yahoo.com [belajar-access] included below]
Dear All
mohon bantuan cara merubah field null jadi 0 agar bisa dihitung
Atas bantuannya saya ucapkan terima kasih
__._,_.___
Posted by: liu_te_hua@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Yahoo Groups
Control your view and sort preferences per Yahoo Group
You can now control your default Sort & View Preferences for Conversations, Photos and Files in the membership settings page.
SPAM IS PROHIBITED
.
__,_._,___
Tidak ada komentar:
Posting Komentar