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

ÈçºÎΪaccessÊý¾Ý¿â¼ÓÃÜ

¸øaccessÊý¾Ý¿â¼ÓÃܵIJ½ÖèÈçÏ£º

£¨1£©´ò¿ªaccessÈí¼þ£¬½çÃæÈçͼ1Ëùʾ

       

                                                      ͼ1

£¨2£©¡°Îļþ¡±——>¡°´ò¿ª¡±——>Ñ¡ÔñÊý¾Ý¿â——>¡°ÒÔ¶ÀÕ¼·½Ê½´ò¿ª¡±£¨Èçͼ2Ëùʾ£©

       

3¡¢¡°¹¤¾ß¡±——>¡°°²È«¡±——¡°ÉèÖÃÊý¾Ý¿âÃÜÂ롱

     

4¡¢ÊäÈë¡°ÃÜÂ롱¡¢¡°ÑéÖ¤¡±——>¡°È·¶¨¡±£»ok£¡
http://photo.blog.sina.com.cn/blogpic/5ff596a20100dqsr/5ff596a2h6d1207b32ccb



Ïà¹ØÎÊ´ð£º

ÓÃVBÇóACCESSÁ½¸ö±íµÄºÍ

ÓÃVBÇóACCESSÁ½¸ö±íµÄºÍ

a±íÀïÓÐ
ID Ãû³Æ ÊýÁ¿ ×ܼÛ
1  a    13  11
2  c    20  20
3  c    2    52
4  b&nb ......

ACCESSÖн¨Á¢Çл»±íµ¥Ê±Óöµ½ÎÊÌâ ÔÚÏßµÈ

ACCESSÖн¨Á¢Çл»±íµ¥,
µã»÷ ¹¤¾ß/×ÊÁϿ⹫ÓóÌʽ/Çл»±íµ¥¹ÜÀíÔ± ºó
Ìáʾ£ºMicrosoft office accessÎÞ·¨½¨Á¢visual basicÄ£×飡
µ½µ×ÊdzöÁËʲ÷áÎÊÌâÄØ£¿
µÚÒ»´ÎÕâÑù½¨Á¢Çл»±íµ¥ÊÇ¿ÉÒԵ쬵«ÊÇÓÉÓÚÓÐ ......

access±íÖÐʱ¼ä²îµÄÉú³É

access±íÖÐÓÐ3¸ö×ֶΣ¬starttime£¬endtime£¬timespan£¬
ÊäÈëǰÁ½¸öÖµºóÔõô×Ô¶¯Éú³ÉtimespanÄØ
´´½¨²éѯ¡£

select *, endtime-starttime from your table


»òÕßÔÚÄãµÄÊäÈë´°ÌåÖÐÓÃVBA´úÂëʵÏÖ¡ ......

ACCESSÊý¾Ý¿â¹ØÁª²éѯÎÊÌ⣿

³õÓÃACCESSÊý¾Ý¿â£¬ÒªÊµÏÖÒ»¸ö¹ØÁª²éѯ£¬sqlÓï¾äÈçÏ£ºselect pid,product_Type.name as tid,name,img_url,context,remark from Product join product_Type on product.type_id = product_Type.type_id order by pid ......

accessÖÐlikeд·¨

sqlÓï¾äÊÇÕâÑùдµÃ 
string sql = "select * from shophistory where username(stringÀàÐÍ)¡¡like '%"+ name +"%' ";
½á¹ûÔËÐб¨´í£º(²Ù×÷·û¶ªÊ§) ÔÚ²éѯ±í´ïʽ  ˵ºó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ