gunakan iif:
select no, usulan, setuju, iif(usulan=setuju,"Ok","No") as keterangan
from table
aksan kurdin
On 1/30/2014 6:36 AM, Ambo Upe wrote:
select no, usulan, setuju, iif(usulan=setuju,"Ok","No") as keterangan
from table
aksan kurdin
On 1/30/2014 6:36 AM, Ambo Upe wrote:
Salam,
Mohon bantuannya, gimna ya cara membuat rumus membandingkan pada tiap record pada field pd query, jika data rekord antar field yg d bandingkan sama maka muncul keterangan "OK" jika berbeda "NO"
Misal query nya seperti ini :No. Usulan Setuju Keterangan (Fourmula/rumus yg d tanya)
1 6 6 Ok
2 8 5 No
Dst........Terima kasih.
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
SPAM IS PROHIBITED
.
__,_._,___
Tidak ada komentar:
Posting Komentar