¹ØÓÚ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Óï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
±¾ÈËÔÚ±àдһ¸öСÐÍÍøÕ¾£¬Êý¾Ý¿âÊÇAccessµÄ£¬ÆäÖÐÓÐÒ»¸ö±íÃûΪ:user,×Ö¶ÎΪÈçÏÂ:
USERID(Ö÷¼ü£¬×Ô¶¯±àºÅ),
ID(Îı¾),
password£¨Îı¾£©,
txtEmail(Îı¾)
Àý£ºÖ´ÐÐÒÔÏÂupdateÓï¾ä£¬ÌáʾÎÞ·¨¸ü ......
SELECT *
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="C:\Documents and Settings\**\My Documents\cc.mdb";User ID=Admin;Password=')...a
ÎÒÖ»ÖªµÀ ......
ÎÒÐèҪͨ¹ýµ¥¸ö²éѯÌõ¼þ°´ÄêÔÂ,²éѯµ½accessÊý¾Ý¿âÀïµÄÊý¾ÝΪ (ÈÕÆÚÀàÐÍ2008-02-02)
Dim DDTP1 As String
Dim date1 ......
Çë½Ì¸ßÊÖ2¸öÎÊÌ⣺
1¡¢¹ØÓÚ²éѯACCESSÒ»¸ö×ֶεÄËùÓмǼÎÊÌ⣻ÔõôÏÂÃæ´úÂëÎÞ·¨´ò¿ªÊý¾Ý¿âѽ£¿
2¡¢ÏÂÃæµÄ´úÂë¿ÉÒÔ·ÃÎÊ¡°¹ú±êÂ롱×Ö¶ÎÖеÄËùÓмǼֵÂð£¿
¼±¼±£¡£¡£¡£¡£¡£¡£¡£¡
vbÓïÑÔ´úÂëÈ ......