| ²é¿´: 127 | »Ø¸´: 2 | ||
| µ±Ç°Ö÷ÌâÒѾ´æµµ¡£ | ||
| ¡¾ÐüÉͽð±Ò¡¿»Ø´ð±¾ÌûÎÊÌ⣬×÷ÕßÎåºþËĺ£½«ÔùËÍÄú 10 ¸ö½ð±Ò | ||
ÎåºþËĺ£Í³æ (ÕýʽдÊÖ)
|
[ÇóÖú]
ÓÐ¹Ø Microsoft Access ±à³ÌÎÊÌ⡾ÓÐЧÆÚÖÁ2008Äê6ÔÂ20ÈÕ¡¿£¬
|
|
|
ÎÒ×î½üÓõ½Microsoft Access£¬ÐèÒª±à³Ì¡£ÎҾͰ´ÕÕexcel µÄ±à³Ì·½·¨±àÁËһϣ¬¿ÉÊDz»ÄÜÓÃŶ£¬ºÇºÇ¡£ ²»ÖªÊ²Ã´Ôµ¹Ê£¿ÇëÖ¸½Ì¡£ ÎÒµÄÈÎÎñÊÇÕâÑùµÄ£ºÐèÒª½«Ä³ÈËÓ¦½ÉµÄ¿î´òÓ¡³öÀ´£¬Êý¾ÝÀ´Ô´ÓÚijһ±í¸ñ¡£Ó¦½É¿îÏîÖ»ÓÐ1100ÔªºÍ1400ÔªÁ½ÖÖ£¬ËùÒÔÎÒ±àÁ˸ö³ÌÐòÊÇÕâÑùµÄ£¨1£©£º =" £¤ " & Mid([×ܶî],1,1) & " " & Mid([×ܶî],2,1) & " " & Mid([×ܶî],3,1) & " " & Mid([×ܶî],4,1) & " " & "0 0" Õâ¸ö³ÌÐòºÜºÃÓ㬵«ÊǺóÀ´Ôö¼ÓÁËÒ»ÖÖÓ¦½É¿î886Ôª£¬ÕâÊÇ3λÊýѽ£¬Èç¹û²»Ð޸ijÌÐò¾Í»á³öÎÊÌ⣺ÒòΪÕâÖÖÇé¿öÏ»Ὣ°ÙλÊý·Åµ½Ç§Î»ÊýÁË£¬ËùÒÔ³ÌÐò¸ÄΪ£¨2£©£º =" £¤ " & Mid([×ܶî],1,1) & " " & Mid([×ܶî],2,1) & " " & Mid([×ܶî],3,1) & " " & "0 0" ¿ÉÊÇ£¬ÓÉÓÚÈËÊýºÜ¶à£¬4λÊýºÍ3λÊý½»²æ³öÏÖ£¬ÎÒ¾ÍÏë±àÒ»¸ö³ÌÐò£ºµ±4λÊýʱ×Ô¶¯Óã¨1£©Ê½£¬¶øÅöµ½3λÊýʱ×Ô¶¯Óã¨2£©Ê½¡£ÎÒÓõÃÊÇexcelÀïµÄIFÓï¾ä£¬ÈçÏ£¨3£© =IF(LEN([×ܶî])=4," £¤ " & Mid([×ܶî],1,1) & " " & Mid([×ܶî],2,1) & " " & Mid([×ܶî],3,1) & " " & Mid([×ܶî],4,1) & " " & "0 0",IF(LEN([×ܶî])=3," £¤ " & Mid([×ܶî],1,1) & " " & Mid([×ܶî],2,1) & " " & Mid([×ܶî],3,1) & " " & "0 0" )²»ÖªÎÒµÄÓï¾äÄÄÀï³ö´íÁË£¬´ò¿ªreport ʱÌáÎÊ IF___________£¬²»ÂÛÌîʲô¶¼ÊÇ´íµÄ¡£Çë´óÏÀÖ¸½Ì¡£ [ Last edited by ÎåºþËĺ£ on 2008-6-11 at 10:17 ] |
» ²ÂÄãϲ»¶
Ò»Ö¾Ô¸ÖØÇì´óѧ085700×ÊÔ´Óë»·¾³×Ü·Ö308Çóµ÷¼Á
ÒѾÓÐ3È˻ظ´
Äϲý´óѧ²ÄÁÏר˶311·ÖÇóµ÷¼Á
ÒѾÓÐ6È˻ظ´
316Çóµ÷¼Á
ÒѾÓÐ6È˻ظ´
346Çóµ÷¼Á[0856]
ÒѾÓÐ7È˻ظ´
һ־Ըɽ´ó07»¯Ñ§ 332·Ö ËÄÁù¼¶Òѹý ±¾¿ÆÉ½¶«Ë«·Ç Çóµ÷¼Á£¡
ÒѾÓÐ3È˻ظ´
310Çóµ÷¼Á
ÒѾÓÐ3È˻ظ´
»úеר˶299Çóµ÷¼ÁÖÁ²ÄÁÏ
ÒѾÓÐ4È˻ظ´
070300»¯Ñ§319Çóµ÷¼Á
ÒѾÓÐ7È˻ظ´
08¹¤¿Æ 320×Ü·Ö Çóµ÷¼Á
ÒѾÓÐ6È˻ظ´
Ò»Ö¾Ô¸Ìì½ò´óѧ»¯Ñ§¹¤ÒÕרҵ£¨081702£©315·ÖÇóµ÷¼Á
ÒѾÓÐ12È˻ظ´

ÎåºþËĺ£
ͳæ (ÕýʽдÊÖ)
- Ó¦Öú: 0 (Ó×¶ùÔ°)
- ½ð±Ò: 164.5
- Ìû×Ó: 415
- ÔÚÏß: 3.3Сʱ
- ³æºÅ: 286162
- ×¢²á: 2006-10-15
- ÐÔ±ð: GG
- רҵ: Nanotechnology

2Â¥2008-06-12 09:29:27
zhanngfengcasc
½ð³æ (ÕýʽдÊÖ)
- Ó¦Öú: 0 (Ó×¶ùÔ°)
- ½ð±Ò: 879.4
- É¢½ð: 150
- Ìû×Ó: 351
- ÔÚÏß: 54.2Сʱ
- ³æºÅ: 442445
- ×¢²á: 2007-10-27
- ÐÔ±ð: GG
- רҵ: ¼ÆËã»úÓ¦Óü¼Êõ

3Â¥2008-06-12 09:44:48













)
»Ø¸´´ËÂ¥