¥»©«³Ì«á¥Ñ 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 |