½d³ò¬O¥Î¨Ó±±¨î¤@¨t¦CªºÈ¡C½d³ò«¬§O¥iÀ³¥Î¦b©Ò¦³Â²³æ«¬§O¡A¦ý¥¬ªL°£¥~¡C¼ÆÈ½d³ò¡B³f¹ô½d³ò¡B¦r¦ê½d³ò¡B¤é´Á½d³ò¡B®É¶¡½d³ò¤Î¤é´Á®É¶¡½d³ò¡C±z¥i¥H¨Ï¥Î To¡B_To¡BTo_¡B_To_¡BIs >¡BIs >=¡BIs < »P Is <= µ¥ÃöÁä¦r¨Ó²£¥Í½d³ò¡C¤@¯ë¦Ó¨¥¡ATo ¥Î©ó¦³¨âÓµ²§ôÂIªº½d³ò¡AIs «h¥Î©ó¶}©ñ©Êªº½d³ò (¥u¦³¤@Óµ²§ôÂI)¡C©³½u²Å¸¹¥Î¨Óªí¥Ü½d³ò¤¤¬O§_¥]§tºÝÂI¡C
¼ÆÈ½d³òȽd¨Ò
±q 2 ¨ì 5 ªº¼Æ¦r½d³ò¡A¥]§t 2 ©M 5¡C
2 To 5
±q2 ¨ì 5 ªº¼Æ¦r½d³ò¡A¤£¥]§t 2¡A¦ý¥]§t 5¡C
2 _To 5
©Ò¦³¤p©ó©Îµ¥©ó 5 ªº¼Æ¦r
Is <= 5
©Ò¦³¤p©ó 5 ªº¼Æ¦r
Is < 5
¤é´Á®É¶¡½d³òȽd¨Ò
#Jan 5, 1999# To #Dec 12, 2000# Is >= #Jan 1, 2000#
¦b Crystal Reports ¤¤¡A¦³ 27 Ө禡¥Î¨Ó«ü©w¤é´Á½d³ò¡C¨Ò¦p¡ALastFullMonth ¨ç¦¡¥i¥Î¨Ó«ü©w¥]§t¤WÓ¤ë±q²Ä¤@¤Ñ¨ì³Ì«á¤@¤Ñ©Ò¦³¤é´Áªº¤é´ÁȽd³ò¡C©Ò¥H¡A°²¦p¤µ¤Ñ¬O 1999 ¦~ 9 ¤ë 15 ¤é¡A¨º»ò LastFullMonth ¨ç¦¡©M CDate (#Aug 1, 1999#) To CDate (#Aug 31, 1999#) ªº½d³òȬO¤@¼Ëªº¡C
If ©Î Select ³¯z¦¡¤¤³Ì±`¨Ï¥Î½d³ò¡C¥H¤U½d¨Ò¬O®Ú¾Ú¹q¸£½Ò¾Ç¥Íªº¦Ò¸Õ¤À¼Æ¡A¨Ópºâ¦¨ÁZµ¥²Ä¡C¤À¼Æ¤j©ó©Îµ¥©ó 90 ¥i±o A¡A¤À¼Æ 80 ¨ì 90 (¦ý¤£¥]§t 90) ¥i±o¨ì B¡A¨Ì¦¹Ãþ±À¡C
Rem pºâ¾Ç¥Í¦¨ÁZµ¥²Ä Select Case {Student.Test Scores} Case Is >= 90 formula = "A" Case 80 To_ 90 formula = "B" Case 70 To_ 80 formula = "C" Case 60 To_ 70 formula = "D" Case Else formula = "F" End Select
¤Wzªº½d¨Ò¨Ï¥Î Select ³¯z¦¡¡A¦b±±¨îµ²ºc¤¤·|¦³§ó¸Ô²Óªº»¡©ú¡C±z¥i¥H¨Ï¥Î In ¹Bºâ¤l¨ÓÀˬd¬YȬO§_¦b½d³ò¤º¡C¨Ò¦p¡G
formula = 5 In 2 To 10 'True formula = 5 In 2 To_ 5 '°² formula = 5 In 2 To 5 'True
Maximum ©M Minimum ¨ç¦¡¥i¥Î¨Ó´M§ä½d³òªººÝÂI¡G
formula = Maximum (2 To 10) '¶Ç¦^ 10