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

[µo°Ý] access ¨ç¼Æ¿z¿ï°ÝÃD iif

[µo°Ý] access ¨ç¼Æ¿z¿ï°ÝÃD iif

½Ð°Ý¤@¤U  =IIf([Ãþ§O]="F**",Round([total]*0.04,0),Round([total]*0.0225,0),([Ãþ§O="S**",Round([total]*0.04,0),Round([total]*0.0225,0),([Ãþ§O]="L**",Round([total]*0.04,0),Round([total]*0.0225,0))))

½Ð°Ý
¦pªG§Ú­n ¶ë¿ï²Å¦X  s f l    ´N­¼¤W§Ú­nªº   ­n¦p¦ó¼g?

¦^´_ 5# ky2599y


    ­ì¨Óround ÁÙ¯àÂ\¦b«e­±  ¡Aiif¦b°t¦Xleft ¨Ï¥Î    ·PÁ¤j¤j«üÂI    ¤S¦h¾Ç¨ì¤F¤@ºØ

TOP

-.-
Round(IIf(Left$([Ãþ§O],1)="F",[total]*0.04,IIf(Left$([Ãþ§O],1)="S",[total]*0.04,IIf(Left$([Ãþ§O],1)="L",[total]*0.04,[total]*0.0225))),0)
Kenny

TOP

¤j¤j §Ú¬Ý¤£¤ÓÀ´@@§Aªº
Iif(left$(Ãþ§O),1)='f',then,false)
¥H¤W¬°¥Ü·N

TOP

§Úı±oround¼g¦b­¼§¹«á´N¤£¥Î¼g¨º»ò¦h¹M¤F¡C
Kenny

TOP

Iif(left$(Ãþ§O),1)='f',then,false)
¥H¤W¬°¥Ü·N
Kenny

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD