µoªí¤H |
¤º®e |
¥DÃD: ¦p¦ó±N¬Y¸ê®Æªíªºµ²ºcÅܦ¨»yªk |
huan388
¦^ÂÐ: 2
Æ[¬Ý: 4698
|
ª©±: 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
Æ[¬Ý: 4496
|
ª©±: 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
Æ[¬Ý: 4496
|
ª©±: 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
Æ[¬Ý: 12500
|
ª©±: 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
Æ[¬Ý: 12500
|
ª©±: 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
Æ[¬Ý: 4417
|
ª©±: 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
Æ[¬Ý: 4165
|
ª©±: 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
Æ[¬Ý: 5564
|
ª©±: 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
Æ[¬Ý: 5564
|
ª©±: 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
Æ[¬Ý: 4950
|
ª©±: 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~? |
|