Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹ØÓÚaccessÊÇ·ñÓÐͳ¼Æ¹¦ÄÜ

  ÎÒ½¨Á¢2¸ö±í,±ÈÈçtable a    table b
  ¼ÙÈçÎÒtable a µÄÖµµÃÊÇÍøÒ³Ìá½»ÊäÈë½øÀ´..
  Äܲ»ÄÜÔÚaccessÓмÆË㹦ÄÜ,¼ÆËã½á¹û¸³Óètable b
 

  Èç:  table  a
          id    time  num1  num2 
          1    8:00    2    5 
          2    8:00    6    7


      table  b 
ÒªµÃµ½µÄЧ¹ûÊÇ:
    id        sum
      1          7(num1+num2)
      2          13(num1+num2)

ÇëÎÊÊÇÓÃaccessÀïÃæµÄ:²éѯ,´°Ìå,±¨±íÄĸö?
SELECT ID,SUM(NUM1+NUM2) from TT GROUP BY ID

SQL code:
insert into b(id,sum) select id,num1+num2 from a


ÇëÎÊÎÒÕâ¸ösqlÓï¾äдµ½ÄÄÀïÄØ

²éѯ,´°Ìå,±¨±í???
ÎÒ¾ÍÏëÓÃaccessÀïÃæ¼ÆËã,²»½èÖú±ðµÄÓïÑÔ

²éѯÖУ¬»òÕß´°ÌåÖÐÓÃVBAÖ´ÐÐ docmd.runsql ¶¼¿ÉÒÔÖ´ÐÐSQLÓï¾ä

ÔÚ²éѯÖУ¬PASTEÉÏÊöSQLÓï¾ä


¼ÓÉÏNZ°É ,ÁÐûÊý¾ÝÒ²ÄܺϼÆ

SELECT ID,SUM(nz(NUM1)+nz(NUM2)) from TT GROUP BY ID

Â¥ÉÏ˵µÃ¶Ô£¬Èç¹ûÄãµÄnum1,num2¿ÉÄܳöÏÖ¿ÕÖµ£¬Ôò½


Ïà¹ØÎÊ´ð£º

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

ΪʲôÔÚaccessÀ¸üÐÂupdate£¬É¾³ýdelete²»ÐÐ?

±¾ÈËÔÚ±àдһ¸öСÐÍÍøÕ¾£¬Êý¾Ý¿âÊÇAccessµÄ£¬ÆäÖÐÓÐÒ»¸ö±íÃûΪ:user,×Ö¶ÎΪÈçÏÂ:

USERID(Ö÷¼ü£¬×Ô¶¯±àºÅ),
ID(Îı¾),
password£¨Îı¾£©,
txtEmail(Îı¾)

Àý£ºÖ´ÐÐÒÔÏÂupdateÓï¾ä£¬ÌáʾÎÞ·¨¸ü ......

SQL2000ÈçºÎ´´½¨ACCESS±í

SELECT *
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="C:\Documents and Settings\**\My Documents\cc.mdb";User ID=Admin;Password=')...a

ÎÒÖ»ÖªµÀ ......

Vb.net Access²éѯ°´ÄêÔÂ


    ÎÒÐèҪͨ¹ýµ¥¸ö²éѯÌõ¼þ°´ÄêÔÂ,²éѯµ½accessÊý¾Ý¿âÀïµÄÊý¾ÝΪ (ÈÕÆÚÀàÐÍ2008-02-02)


        Dim DDTP1 As String

        Dim date1 ......

¼±¼±£¡£¡¹ØÓÚ²éѯACCESSÒ»¸ö×ֶεÄËùÓмǼÎÊÌâ

Çë½Ì¸ßÊÖ2¸öÎÊÌ⣺
1¡¢¹ØÓÚ²éѯACCESSÒ»¸ö×ֶεÄËùÓмǼÎÊÌ⣻ÔõôÏÂÃæ´úÂëÎÞ·¨´ò¿ªÊý¾Ý¿âѽ£¿
2¡¢ÏÂÃæµÄ´úÂë¿ÉÒÔ·ÃÎÊ¡°¹ú±êÂ롱×Ö¶ÎÖеÄËùÓмǼֵÂð£¿


¼±¼±£¡£¡£¡£¡£¡£¡£¡£¡

vbÓïÑÔ´úÂëÈ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ