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

ΪʲôAccess²»Ö§³ÖÄØ£¿

ÈçÏÂÓï¾ä
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Àï²âÊÔʱûÓÐÎÊÌâµÄ
¶øÔÚaccessÀïÃæÈ´Ìáʾ£º²»Ö§³ÖÁ¬½Ó±í´ïʽ¡£
µ½µ×ÊÇÄÄÀïµÄÎÊÌâÄØ£¿
лл£¡
access學習~~~

ÒýÓÃ
access學習~~~
up

SQL code:
--try
Select
[Name] as sUnit, count(*) as sTime
from
Cl_BreakRecord ,Cl_Group
where
GroupID = Cl_Group.ID
and
DepartmentID = 3
group by
[Name]
order by
sTime desc


ÄÉÃÆÁË£¬Ã÷Ã÷accessÒ²Ö§³Ö inner join µÄ

1.join ²»Ö§³ÖÁÐÃûÓë³£ÊýµÄÁ¬½Ó Ö§³ÖÁÐÃûÓëÁÐÃûµÄÁ¬½Ó
2.ÓÃwhere ¿ÉÒÔʵÏÖ
3.order by ²»ÄÜÓÃÐÂÁбðÃû£¬¿ÉÒÔÓþۺϺ¯Êý»òÁÐ˳ÐòºÅ

thanks!

Óï·¨²»Ö§³Öѽ


Ïà¹ØÎÊ´ð£º

asp¸úAccessÊý¾ÝÁ¬½ÓÎÊÌâ¡£

IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)

'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......

ACCESSÊý¾Ý¿âÓëVB¿ª·¢µÄÈí¼þ½øÐл¥Á¬ÍøÁ¬½Ó

±¾À´ÎÒÊÇÓÃACCESS+VB½¨Á¢Ò»¸öÈí¼þ£¨¾ÖÓòÍø£©£¬ÏÖÔÚÓÉÓڰ칫µØµãÓб䶯£¬Ïà»»³ÉINTERNATµÄ£¬ÓÐûÓа취½â¾ö£¬

ÏóÕâÑùµÄÇé¿ö£¬Èç¹ûÊǹãÓòÍø£¬×îºÃ¸Ä³É£ºB\SµÄ
Èç¹ûÊǾÖÓòÍøµÄ£¬×îºÃ¸Ä³É£ºC\SµÄ
http://downlo ......

ACCESSÊý¾Ý¿â²ð·ÖµÄÎÊÌâ

ÎÒ×öÁËÒ»¸öѧÉú»ñ½±ÐÅÏ¢µÄ±í£¬ÀïÃæ×Ö¶ÎÓкܶ࣬È磺ѧºÅ£¬ÐÕÃû£¬°à¼¶£¬ÁªÏµ·½Ê½£¬Äê¼¶£¬ÐÔ±ð£¬100Ã×£¬200Ã×£¬CET4£¬¼ÆËã»úµÈ¼¶,±¨¹ØÔ±£¬±¨¼ìÔ±£¬µÈµÈºÜ¶à£¬Ôõô²ð·Ö³É¼¸¸ö±í£¬ÈçºÎ×éÖ¯±í¼ä¹ØÏµ?
´ÓÄãµÄ˵Ã÷ÉÏ¿´²»³ö ......

accessÖеÄfull join

    ÏÖÐèÒª½«access 2007ÖеÄ42¸ö±í½øÐÐfull join¡£ÓÉÓÚaccessÖв»ÄÜÖ´ÐÐfull join£¬Èç¹û²ÉÓÃleft join union right joinµÄ·½Ê½£¬ÐèÒª¶ÔÕâ42¸ö±íÒ»Ò»½øÐУ¬½«²úÉú´óÁ¿µÄ²»±ØÒªµÄÖмäÊý¾Ý£¬Ôö´óÁËÊý¾Ý¿âµÄ¿ ......

MSHFelxGrid Óë ACCESS MEMOÀàÐÍ×ֶεÄÒÉÎÊ

×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ

µ±Êý¾Ý¿â×Ö¶ÎÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ