vc ÔõôµôÓà Access ×Ô¼ºÉè¼ÆºÃµÄ²éѯ
Ë×ö¹ýÕâ·½ÃæµÄ,°ÝÇó..ÌáÐÑÒ»ÏÂ,ÎÒËùÓеķֶ¼ËÍÄã~~~~
Ö±½ÓºÍµ÷ÓñíÏàͬ¡£ select * from table1 select * from qeury1ÒýÓà ÌáÐÑÒ»ÏÂ,ÎÒËùÓеķֶ¼ËÍÄã~~~~ ( ¿ÉÐŶȲ»¸ß°¡) Liang4 (ÁºËÄ) '½ØÖÁ2009-09-15 14:13:35 Óû§½áÌûÂÊ12.50% ×Ü·¢Ìû£º8 Õý³£½áÌû£º0 δ½áÌû£º7 access ²ÎÊý²éѯ°¡.... ÄãÄǸö²éѯµÄÓï¾ä±ØÐëÏÈдºÃÔÚ²éѯÎļþÀï²Å¿ÉÒÔ Â¥Éϵģ¬ÎÒÕÒÁ˺ܾÃÁË£¬Äã˵µÄ·½·¨¾ÍÊÇÎÒÏëÒªµÄ Ö»¿ÉϧÎÒÏÖÔÚûÓÐmsdn,¶ÔÕ⼸¸öÀàÒ»µã²»Êì,Äã˵µÄ·¶ÀýÔÚʲôÊéÀïÓÐ?
Ïà¹ØÎÊ´ð£º
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡ ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖà sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£ ÊÇ ......
ÎÊÌâÈçÏ£º ÓòéѯÓï¾ä select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´ ¸ÄΪ select * from tab where fil = 'CK090902' ¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í ¶ÁÈ¡Êý¾Ý È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡ Ò»´ÎÈ«²¿¶ÁÍê ......