| µoªí¤H | 
	¤º®e | 
  
  
	   ¥DÃD: ¦p¦ó±N¬Y¸ê®Æªíªºµ²ºcÅܦ¨»yªk | 
  
  
	huan388 
	   
	  ¦^ÂÐ: 2 
	  Æ[¬Ý: 4869 
	 | 
	 ª©±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¥| ¤Q¤ë 16, 2008 10:22 am   ¥DÃD: ¦p¦ó±N¬Y¸ê®Æªíªºµ²ºcÅܦ¨»yªk | 
  
  
	¨Ò¦p
 ¥Î»yªk
 CREATE TABLE sample (age n(10),name c(10))
 ¥i¥H³Ð³y¥X¦W¬° sameple  ¥]§tage »P name ¨âÓÄæ¦ìªº¸ê®Æªí
 
 ¨º¯à¤£¯à¤Ï¦V ±q¤@Óªí µM«á²£¥X¬Û¹ïÀ³Äæ¦ìµ²ºcªº»yªk
 Åý§Ú¥i¥H°O¿ý³oÓ»yªk
 ¤U¦¸°õ¦æ ... | 
  
  
	   ¥DÃD: ¦p¦ó¤£Åýprg ²£¥ÍfxpªºÀÉ®× | 
  
  
	huan388 
	   
	  ¦^ÂÐ: 2 
	  Æ[¬Ý: 4655 
	 | 
	 ª©±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤G ¤Q¤ë 14, 2008 9:31 am   ¥DÃD: ¦p¦ó¤£Åýprg ²£¥ÍfxpªºÀÉ®× | 
  
  
	¨þ¨þ¨þ ì¨Ó¦p¦¹°Ú
 ·PÁ«ü¾É | 
  
  
	   ¥DÃD: ¦p¦ó¤£Åýprg ²£¥ÍfxpªºÀÉ®× | 
  
  
	huan388 
	   
	  ¦^ÂÐ: 2 
	  Æ[¬Ý: 4655 
	 | 
	 ª©±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤@ ¤Q¤ë 13, 2008 5:30 pm   ¥DÃD: ¦p¦ó¤£Åýprg ²£¥ÍfxpªºÀÉ®× | 
  
  
	¨C¦¸°õ¦æ§¹prgµ{¦¡ ³£·|²£¥Í¤@Ó¦P¼Ë¦WºÙªº .fxp
 ¦³¿ìªk³]©w¤£n²£¥Ífxp¶Ü
 ·PÁÂ | 
  
  
	   ¥DÃD: §Q¥ÎVFP°µ¥X¤Gºûªí | 
  
  
	huan388 
	   
	  ¦^ÂÐ: 9 
	  Æ[¬Ý: 13044 
	 | 
	 ª©±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤@ ¤Q¤ë 13, 2008 5:28 pm   ¥DÃD: §Q¥ÎVFP°µ¥X¤Gºûªí | 
  
  
	chilin¥S
 «Ü·PÁ§A
 §A¨º¬qµ{¦¡½X´N¬O§Ú·Qnªº
 ³oÃä°ª¤â¯uªº«Ü¦h
 ¨ä¥L¤jô¤]¤@¨Ö·PÁÂ°Õ | 
  
  
	   ¥DÃD: §Q¥ÎVFP°µ¥X¤Gºûªí | 
  
  
	huan388 
	   
	  ¦^ÂÐ: 9 
	  Æ[¬Ý: 13044 
	 | 
	 ª©±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤@ ¤Q¤ë 06, 2008 4:37 pm   ¥DÃD: §Q¥ÎVFP°µ¥X¤Gºûªí | 
  
  
	¦U¦ì¤jô¦n
 ¸ò¦U¦ì½Ð±Ð¸Ó¦p¦ó¥Îµ{¦¡§âÃþ¦ü¥H¤U¥H¤U¸ê®ÆÅܦ¨¤Gºûªí
 Ãþ¦ü°µ¥XEXCELªº¼Ï¯Ã¤ÀªRªí
 
 °²³]¦³ªí TABLE_A   ²Ä¤@¦C¬°Äæ¦ì¦WºÙ  ¸ê®Æ¦p¤U
 
 ¤ë¥÷     ³æ¦ì    ª÷ÃB
 ------------------
 9702    ªF°Ï    ... | 
  
  
	   ¥DÃD: ¦AEXCEL2000¦ÛqÃþ¦üEXCEL2007ªºSUMIFS() ¨ç¼Æ | 
  
  
	huan388 
	   
	  ¦^ÂÐ: 1 
	  Æ[¬Ý: 4679 
	 | 
	 ª©±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤ ¤G¤ë 29, 2008 10:47 am   ¥DÃD: ¦AEXCEL2000¦ÛqÃþ¦üEXCEL2007ªºSUMIFS() ¨ç¼Æ | 
  
  
	½Ð±Ð¦U¦ì°ª¤â
 
 EXCELL 2007·í¤¤¦³Ó«Ü¦n¥Îªº¨ç¼Æ SUMIFS()
 
 EXCEL2000·í¤¤¥u¦³ SUMIF
 
 ½Ð±Ð«ç»ò§Q¥ÎVBA¨Ó¦Ûq¨ç¼ÆÅý2000¤]¯à¨Ï¥ÎSUMIFS©O
 ·PÁ¦U¦ì¤jô | 
  
  
	   ¥DÃD: ¦p¦óÅývfp±±¨î¥Ø«e¤w¸g¶}±Òªºexcel¬¡¶Ã¯ | 
  
  
	huan388 
	   
	  ¦^ÂÐ: 1 
	  Æ[¬Ý: 4282 
	 | 
	 ª©±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤é ¤K¤ë 19, 2007 7:47 pm   ¥DÃD: ¦p¦óÅývfp±±¨î¥Ø«e¤w¸g¶}±Òªºexcel¬¡¶Ã¯ | 
  
  
	¤§«eª¦¤å
 ª¾¹D
 oleApp = CREATEOBJECT(¡²Excel.Application¡²)
 ¡@¡@oleApp.Visible=.T. ¡®¡® Åã¥Ü Excel¡C
 ¡@¡@oleApp.Workbooks.Add 
 ¥i¥H·s¼W¤@Ó¬¡¶Ã¯ ¨Ã¦b¸Ó¬¡¶Ã¯°Ê§@
 ¨º¤°»ò»yªk¥i¥H§âvfpªº¼Æ¾Ú¼g¤J¥Ø« ... | 
  
  
	   ¥DÃD: ¿Ã¹õ¤Wªº¦rµLªk½Æ»s¶Ü? | 
  
  
	huan388 
	   
	  ¦^ÂÐ: 3 
	  Æ[¬Ý: 5780 
	 | 
	 ª©±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤é ¤K¤ë 19, 2007 2:37 pm   ¥DÃD: ¿Ã¹õ¤Wªº¦rµLªk½Æ»s¶Ü? | 
  
  
	¥i¥H¥Î¤F ¨S·Q¨ì³o»ò²³æ
 ·PÁ¤jô | 
  
  
	   ¥DÃD: ¿Ã¹õ¤Wªº¦rµLªk½Æ»s¶Ü? | 
  
  
	huan388 
	   
	  ¦^ÂÐ: 3 
	  Æ[¬Ý: 5780 
	 | 
	 ª©±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤é ¤K¤ë 19, 2007 12:55 am   ¥DÃD: ¿Ã¹õ¤Wªº¦rµLªk½Æ»s¶Ü? | 
  
  
	¤p§Ì¸g±`·|»Ýn§Q¥Î¦p
 SUM...TO n
 ?n
 ¥i¬O¿é¥X¿Ã¹õ¤Wªºµe±µLªk½Æ»s¤å¦r
 §Ú¸g±`¥u¬O®{µM»Ýn¥[Á`¬YӼƦr
 ¦³¿ìªkÅý¥L¥i¥H½Æ»s¶Ü¡H
 
 ©Î¬O¦³¿ìªkÅý¥¦«Ü²«K§Ö³tªº§â¼Æ¦r¶K¦b¶}±Ò¤¤ªºexcel ¤u§@ªí¤¤¹À~? | 
  
  
	   ¥DÃD: TABLEÀÉ®×¶W¹L2G | 
  
  
	huan388 
	   
	  ¦^ÂÐ: 2 
	  Æ[¬Ý: 5115 
	 | 
	 ª©±: VFP °Q½×°Ï   µoªí©ó: ¬P´Á¤é ¤K¤ë 19, 2007 12:38 am   ¥DÃD: TABLEÀÉ®×¶W¹L2G | 
  
  
	¤p§Ì¤u§@ªº¤½¥q ¸ê®Æªí¤w¸gÃzªí(¤j©ó2G¨î)
 ²{¦b°µªk¬O§â¤º®e¤À©î
 ¥i¬OºCºC«Ü¦h³£§ÖnÃz¤F
 ½Ð°Ý¦³¨S¦³¿ìªk¥i¥H¸Ñ¨M©O~? | 
  
  
	|    |