Coba edit source querynya dengan mengandaikan nilai record adalah numeric:
SisaSaldo: IIf(IsNumeric([NilaiFaktur]);[NilaiFaktur];0)-IIf(IsNumeric([NilaiRetur]);[NilaiRetur];0)-IIf(IsNumeric([NilaiBayar]);[NilaiBayar];0)-IIf(IsNumeric([NilaiBiaya]);[nilaiBiaya];0)
Semoga bisa membantu dan memberi semangat.
Hariyanto (Surabaya)
--------------------------------------------
On Wed, 16/7/14, dedy heru susanto d3dy_h3rus@yahoo.com [belajar-access] <belajar-access@yahoogroups.com> wrote:
Subject: [belajar-access] Rubah Null jadi 0 [1 Attachment]
To: belajar-access@yahoogroups.com
Date: Wednesday, 16 July, 2014, 9:41 PM
[Attachment(s) from dedy heru susanto
d3dy_h3rus@yahoo.com [belajar-access] included below]
Dear Allmohon
bantuan cara merubah field null jadi 0 agar bisa
dihitungAtas bantuannya saya ucapkan terima
kasih
Attachment(s)
from dedy heru susanto d3dy_h3rus@yahoo.com
[belajar-access] | View
attachments on the web
1 of 1 File(s)
Aplikasi
Penjualan.mdb
Posted by: hari yanto <har_i20002000@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar