accessÖÐdistinctµÄÓ÷¨
ÎÒÓõÄaccess2003£¬±íÊý¾ÝÈçÏ£º col1 col2 zhao 22 zhang 33 zhao 14 zhao 12 Ï£Íû¶ÁÈ¡col1²»Öظ´µÄËùÓÐ×ֶΣ¬¶øÇÒÖ»¶Á²»Öظ´µÄcol1µÄËùÓмǼµÄµÚÒ»Ìõ£¬°´ÕÕcol2ÅÅÐò£¬sqlÓï¾ä¸ÃÔõôд£¿ ½á¹ûÓ¦¸ÃÊÇ£º col1 col2 zhang 33 zhao 12
ÒýÓà ²Î¿¼ Èç¹ûÊÇÀàËÆÏÂÃæµÄ²éѯÓï¾ä,¾ÍûÎÊÌâ: select distinct ×Ö¶Î from ±í Èç¹ûÊÇÓÃÔھۺϺ¯ÊýÖÐ,¾Í²»Ö§³Ö. select count(distinct ×Ö¶Î) from ±í Ò²¿ÉÒÔתÍäÒ»ÏÂд¸ö¼æÈÝmssqlºÍaccess µÄ´úÂë select count(*) from T group by ×Ö¶Î select col1 from tab group by col1 select count(*) as tab from (select distinct a from tab ) ÒÔÉÏÎÒûÊԳɹ¦£¬Çë×¢Ò⣬Èç¹ûÓÐ3Ìõ¼Ç¼µÄcol1ÊÇÖØ¸´µÄ£¬ÄÇôֻ¶ÁȡһÌõ¼Ç¼ ÕâÀïÃæÃ»ÓÐÉæ¼°µ½ÇóºÍ£¬Ö»ÊǶÁ³öÀ´²»Öظ´Ä³×ֶεÄËùÓмǼ£¬µ±È»¸Ã¼Ç¼Ҫ°üÀ¨ËùÓÐ×Ö¶Î
Ïà¹ØÎÊ´ð£º
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ ±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
µÚÒ»´Î½Ó´¥CrystalReport ¼±Ñ°ÕÒVb.net Access ͨ¹ý²éѯ³öµÄÊý¾ÝÊä³öµ½CrystalReportµÄÀý×Ó. ÓеÄÅóÓÑÂé·³·¢À´Ñ§Ï°.¶àл! ¸úÄãµÄÒªÇó²î²»¶à£¬²Î¿¼Ò»Ï£º http://topic.csdn.net/u/20090823/21/87af02d3-f4ca-480 ......
ÈçºÎÐÞ¸Ämsysobjects±íÖеÄÊý¾ÝÄØ£¿Ð»Ð» ɶ¶¼Ã»ÓÐ,Òâ˼²»Ã÷È·,ÔÙÏêϸµã°É ²»Òª¸ÄsysobjectsÀïµÄ¶«Î÷¡£ ÓÃÆäËü·½·¨¸Ä£¬±íÃû»òÆäËû¡£ ÒªÔÚACCESS»·¾³ÏÂÅäÖÃȨÏÞ£¬²ÅÄÜ·ÃÎÊϵͳ±í... лл´ó¼Ò¡£ ÊÇÕâÑù£¬¿´ ......
ÎÒ×öÁËÒ»¸öС³ÌÐò£¬ÏëʵÏֵŦÄܾÍÊÇÔÚÎı¾¿òÖÐÊäÈëÐÕÃû£¬µã»÷²éѯ°´Å¥£¬¾ÍÄܲ鵽ACCESSÊý¾Ý¿âÖдËѧÉúµÄÐÅÏ¢£¨±àºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣩¿ÉÎÒ²»ÖªµÀÓï·¨¸ñʽ£¬ÎÒ×Ô¼ºÐ´µÄÓï¾äµ÷ÊÔÄÜͨ¹ý£¬¿ÉÊÇÔËÐÐʱ³ö´í£¨µã»÷²éѯ°´ ......
±í½á¹¹: table1 Ö¤¼þºÅ ʱ¼ä X31 2010-01-11 3BC 2010-02-03 3AD 2010-02-03 F23 2010-02-09 ...... ÏÖÔÚҪͳ¼ÆÒ»¸öʱ¼ä¶ÎÈç 2010-01-09 µ½ 2010-02-09¼äµÄÊý¾Ý, ÆÚ´ý½ ......