ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[±Ð¾Ç] Nz(),ªÅ­È¸É¤W¹s¦r¦ê "0"

[±Ð¾Ç] Nz(),ªÅ­È¸É¤W¹s¦r¦ê "0"

¥»©«³Ì«á¥Ñ HSIEN6001 ©ó 2012-7-29 15:22 ½s¿è

Ãö©óNz(),ªÅ­È¸É¤W¹s¦r¦ê "0"
¥ý«e¹J¨ìªº§xÂZ¤w¦Û¦æ¸Ñ¨M
¾ã²z«á,¦b¦¹¤À¨É

¬d¸ß¤§Äæ¦ì­È=ªÅ ,¤£¦s¦b--->¥iÀ³¥ÎCDbl(Nz(field, 0)),Åý¸ÓÄæ¦ì¸É¤W 0 ¼Æ­È
¤è«K¦bAccess¥[Á`Åçºâ
But ¦b VBA¨ú¥X¸ê®Æ®w®É·|²£¥ÍNz ¦¹¨ç¼Æ©w¸q Err

¸Ñ¨M: §ï¼g¦¨
IIf(Is Null(field)=True,0,field) ©Î IIf(field Is Null,0,field)

SQL:
select IIf(Is Null(field),0,field)
from table

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD