Bang Aksan, maaf blm bisa tuh.baik dg query view maupun sql.
dlm query sy pake--> Hitung: Last(IIf([stockakhir]=0;[ready];[stockakhir]))
pada kondisi di mana stock fisik tdk =0 maka HITUNG benar, namun jika nilai stockakhir=0 maka
nilai ready yg di tampilkan.
bagaimana cara agar nilai hitung bisa mengambil nilai 0 tsb, tanpa mengubah nilai ready.
tks
On Saturday, March 29, 2014 9:37 AM, aksan kurdin <aksan.kurdin@gmail.com> wrote:
jika nilaihitung=0 maka nilaiakhir=0 , dan jika tdk 0 maka
nilaihitung=nilaiawal
nilaiakhir:iif(nilaihitung=0;0;nilaiawal)
aksan kurdin
On Friday, March 28, 2014 9:57:13 PM, cmentari7@yahoo.com wrote:
> Salam jumpa, maaf lama tidak gabung, dan lama tdk pegang access lg,
> Pak Admin dan tmn2. mohon di bantu expresion pada query access seperti
> ini :
>
> nilaihitung A =0
> nilaiawal B=2
> jika nilaihitung=0 maka nilaiakhir=0 , dan jika tdk 0 maka
> nilaihitung=nilaiawal.
> kasus :
> nilaiakhir: First((IIf([nilaihitung]=0;[nilaiawal])))
> tapi tdk akurat.
>
> mohon script sql nya pls.
> terima kasih
> salam..
>
>
------------------------------------
SPAM IS PROHIBITEDYahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)
<*> To change settings via email:
belajar-access-digest@yahoogroups.com
belajar-access-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
nilaihitung=nilaiawal
nilaiakhir:iif(nilaihitung=0;0;nilaiawal)
aksan kurdin
On Friday, March 28, 2014 9:57:13 PM, cmentari7@yahoo.com wrote:
> Salam jumpa, maaf lama tidak gabung, dan lama tdk pegang access lg,
> Pak Admin dan tmn2. mohon di bantu expresion pada query access seperti
> ini :
>
> nilaihitung A =0
> nilaiawal B=2
> jika nilaihitung=0 maka nilaiakhir=0 , dan jika tdk 0 maka
> nilaihitung=nilaiawal.
> kasus :
> nilaiakhir: First((IIf([nilaihitung]=0;[nilaiawal])))
> tapi tdk akurat.
>
> mohon script sql nya pls.
> terima kasih
> salam..
>
>
------------------------------------
SPAM IS PROHIBITEDYahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)
<*> To change settings via email:
belajar-access-digest@yahoogroups.com
belajar-access-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
SPAM IS PROHIBITED
.
__,_._,___
Tidak ada komentar:
Posting Komentar