[belajar-access] Re: pembagian dengan 0

gunakan iif , contoh

SELECT Table1.nilai, Table1.pembagi, IIf([pembagi]=0,0,[nilai]/[pembagi]) AS hasil FROM Table1;

'====
--- In belajar-access@yahoogroups.com, irawan <irawan@...> wrote:
>
> Rekan2x yang terhormat
>
> Bagaimana caranya agar di dalam query pembagian dengan 0 tidak
> menghasilkan #ERROR
>
> terima kasih sebelumnya..
>

------------------------------------

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:
http://docs.yahoo.com/info/terms/