ACCESS FEED: Re: [belajar-access] cara memberikan suatu ekspresi nilai terhadap isi suatu cell [1 Attachment]

Jumat, 19 Juni 2015

Re: [belajar-access] cara memberikan suatu ekspresi nilai terhadap isi suatu cell [1 Attachment]

[Attachment(s) from hari yanto har_i20002000@yahoo.com [belajar-access] included below]

Sugenk Freeono ....,

Sama-sama, kita juga mengucapkan selamat menunaikan Ibadah Puasa bagi yang menjalani.

Untuk mendeteksi field berisi nilai atau tidak, kalau menggunakan query ms Access bisa memanfaatkan fungsi iif (kalau di vba hanya if).

Contoh iif([ta]<>"";"Berisi";"Kosong")
artinya jika field ta ada isinya, beri nilai BERISI. Sebaliknya beri nilai KOSONG.

Terlampir adalah contohnya.

Semoga bisa membantu dan memberi semangat.

Hariyanto (Surabaya)

--------------------------------------------
On Thu, 18/6/15, Sugenk Freeono sfreeono@yahoo.com [belajar-access] <belajar-access@yahoogroups.com> wrote:

Subject: [belajar-access] cara memberikan suatu ekspresi nilai terhadap isi suatu cell
To: belajar-access@yahoogroups.com
Date: Thursday, 18 June, 2015, 4:40 PM

Sebelumnya
saya mengucapkan selamat menjalankan ibadah puasa u semua
rekan2 forum access yg sdg berpuasa

Mohon bantuan petunjuk rekan2
senior bagaimana caranya memberikan suatu ekspresi nilai
terhadap isi suatu cell
misal sy mempunyai tabel/query yg
berisi field sbb : no_drawing, no_weld, date_weld, rt_acc
catatn: field rt_acc
isinya berupa no.surat
bagaimana caranya agar hasil di
report supaya isi field rt_acc menjadi berupa nilai
"YES", dan tdk ada isi/kosong jk cell bernilai
null/kosong
dengan menggunakan builder query
kira2 fungsi apa yg dpt digunakan apakah if,countif, ...
?

mohon maaf
sebelumnya jk junior selalu bertanya.. Terima kasih...

Salam

#yiv5236853920 #yiv5236853920 --
#yiv5236853920ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv5236853920 #yiv5236853920ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv5236853920 #yiv5236853920ygrp-mkp #yiv5236853920hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv5236853920 #yiv5236853920ygrp-mkp #yiv5236853920ads {
margin-bottom:10px;}

#yiv5236853920 #yiv5236853920ygrp-mkp .yiv5236853920ad {
padding:0 0;}

#yiv5236853920 #yiv5236853920ygrp-mkp .yiv5236853920ad p {
margin:0;}

#yiv5236853920 #yiv5236853920ygrp-mkp .yiv5236853920ad a {
color:#0000ff;text-decoration:none;}
#yiv5236853920 #yiv5236853920ygrp-sponsor
#yiv5236853920ygrp-lc {
font-family:Arial;}

#yiv5236853920 #yiv5236853920ygrp-sponsor
#yiv5236853920ygrp-lc #yiv5236853920hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv5236853920 #yiv5236853920ygrp-sponsor
#yiv5236853920ygrp-lc .yiv5236853920ad {
margin-bottom:10px;padding:0 0;}

#yiv5236853920 #yiv5236853920actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv5236853920 #yiv5236853920activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv5236853920 #yiv5236853920activity span {
font-weight:700;}

#yiv5236853920 #yiv5236853920activity span:first-child {
text-transform:uppercase;}

#yiv5236853920 #yiv5236853920activity span a {
color:#5085b6;text-decoration:none;}

#yiv5236853920 #yiv5236853920activity span span {
color:#ff7900;}

#yiv5236853920 #yiv5236853920activity span
.yiv5236853920underline {
text-decoration:underline;}

#yiv5236853920 .yiv5236853920attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv5236853920 .yiv5236853920attach div a {
text-decoration:none;}

#yiv5236853920 .yiv5236853920attach img {
border:none;padding-right:5px;}

#yiv5236853920 .yiv5236853920attach label {
display:block;margin-bottom:5px;}

#yiv5236853920 .yiv5236853920attach label a {
text-decoration:none;}

#yiv5236853920 blockquote {
margin:0 0 0 4px;}

#yiv5236853920 .yiv5236853920bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv5236853920 .yiv5236853920bold a {
text-decoration:none;}

#yiv5236853920 dd.yiv5236853920last p a {
font-family:Verdana;font-weight:700;}

#yiv5236853920 dd.yiv5236853920last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv5236853920 dd.yiv5236853920last p
span.yiv5236853920yshortcuts {
margin-right:0;}

#yiv5236853920 div.yiv5236853920attach-table div div a {
text-decoration:none;}

#yiv5236853920 div.yiv5236853920attach-table {
width:400px;}

#yiv5236853920 div.yiv5236853920file-title a, #yiv5236853920
div.yiv5236853920file-title a:active, #yiv5236853920
div.yiv5236853920file-title a:hover, #yiv5236853920
div.yiv5236853920file-title a:visited {
text-decoration:none;}

#yiv5236853920 div.yiv5236853920photo-title a,
#yiv5236853920 div.yiv5236853920photo-title a:active,
#yiv5236853920 div.yiv5236853920photo-title a:hover,
#yiv5236853920 div.yiv5236853920photo-title a:visited {
text-decoration:none;}

#yiv5236853920 div#yiv5236853920ygrp-mlmsg
#yiv5236853920ygrp-msg p a span.yiv5236853920yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv5236853920 .yiv5236853920green {
color:#628c2a;}

#yiv5236853920 .yiv5236853920MsoNormal {
margin:0 0 0 0;}

#yiv5236853920 o {
font-size:0;}

#yiv5236853920 #yiv5236853920photos div {
float:left;width:72px;}

#yiv5236853920 #yiv5236853920photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv5236853920 #yiv5236853920photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv5236853920 #yiv5236853920reco-category {
font-size:77%;}

#yiv5236853920 #yiv5236853920reco-desc {
font-size:77%;}

#yiv5236853920 .yiv5236853920replbq {
margin:4px;}

#yiv5236853920 #yiv5236853920ygrp-actbar div a:first-child {

margin-right:2px;padding-right:5px;}

#yiv5236853920 #yiv5236853920ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv5236853920 #yiv5236853920ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv5236853920 #yiv5236853920ygrp-mlmsg select,
#yiv5236853920 input, #yiv5236853920 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv5236853920 #yiv5236853920ygrp-mlmsg pre, #yiv5236853920
code {
font:115% monospace;}

#yiv5236853920 #yiv5236853920ygrp-mlmsg * {
line-height:1.22em;}

#yiv5236853920 #yiv5236853920ygrp-mlmsg #yiv5236853920logo {
padding-bottom:10px;}

#yiv5236853920 #yiv5236853920ygrp-msg p a {
font-family:Verdana;}

#yiv5236853920 #yiv5236853920ygrp-msg
p#yiv5236853920attach-count span {
color:#1E66AE;font-weight:700;}

#yiv5236853920 #yiv5236853920ygrp-reco
#yiv5236853920reco-head {
color:#ff7900;font-weight:700;}

#yiv5236853920 #yiv5236853920ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv5236853920 #yiv5236853920ygrp-sponsor #yiv5236853920ov
li a {
font-size:130%;text-decoration:none;}

#yiv5236853920 #yiv5236853920ygrp-sponsor #yiv5236853920ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv5236853920 #yiv5236853920ygrp-sponsor #yiv5236853920ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv5236853920 #yiv5236853920ygrp-text {
font-family:Georgia;}

#yiv5236853920 #yiv5236853920ygrp-text p {
margin:0 0 1em 0;}

#yiv5236853920 #yiv5236853920ygrp-text tt {
font-size:120%;}

#yiv5236853920 #yiv5236853920ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv5236853920