Access Êý¾Ý²éѯ²»ÍêÕû
select * from ±íÃû
±íÀïÓÐ100ÌõÊý¾Ý£¬¿ÉÊÇÖ»²éѯ³öǰ90Ìõ£¬ÆäÓàµÄ²»ÏÔʾ¡£ÒªÊǸù¾ÝID²éѯ£¬ÆäÓàµÄÒ²¿ÉÒԲ鵽¡£
ÕâÊÇʲôÎÊÌâ°¡£¿
ѹËõMDBÊÔÊÔ¡¡OR¡¡Ð½¨Ò»¸öMDB£¬µ¼Èë¾É±íÊý¾Ý£¬ÔÙ²éѯÊÔÊÔ
ÉÏ´«ÄãµÄ±í£¬ÕâÑù¸ü¿ì£¬ÒòΪÄãÕâÑùÎÊ£¬´ó¼Ò¶¼ÊÇÓòµÄ
ÊDz»ÊÇMDBÎļþËð»µ?
´ÓACCESSµÄ²Ëµ¥ÉÏѹËõÐÞ¸´ÒÔÏÂ
ÎÊÌâÕÒµ½ÁË£¬select * from ±íÃû Ö±½ÓÕâÑùµÄ²éѯµÄ»°Ë³ÐòÓеãÂÒ£¬×îºóµÄÄǼ¸¸öÅܵ½Ç°ÃæÈ¥ÁË¡£ÅÅÏÂÐò¾ÍºÃÁË
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......
ÈçÏÂÓï¾ä
Select [Name] as sUnit, count(*) as sTime from Cl_BreakRecord inner join Cl_Group On GroupID = Cl_Group.ID and DepartmentID = 3 group by [Name] order by sTime desc
ÔÚsqlÀï²âÊÔʱûÓÐ ......
ÈçºÎÔÚvcÖÐʹÓÃADOXΪaccessÊý¾Ý¿âÌí¼ÓÒ»¸öÓû§?
лл!
ßí?ÔõôûÈËÀ´¿´¿´Ñ½?
ÎÒŪ ÁË ºÃ¾ÃÁË,¶¼Ã»Ò»µãÍ·Ð÷!
ÄÇλ´ó´óÀ´¾È¾È¼±Ñ½!
ллÁË!
Ìí¼ÓÒ»¸öÓû§ÊÇʲôÒâ˼£¿£¿Ìí¼ÓÒ»ÕÅ±í£¿£¿»¹ÊÇ´´½¨Ò» ......