Results 1 to 7 of 7

Thread: MS ACCESS

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Darknauss's Avatar
    Join Date: Mar:2005
    Location: Sofia/Vienna
    Posts: 2,151

    Unhappy MS ACCESS

    ,

    , .
    REG
    REG.NC=2 AND REG.DEG_CODE=205 e
    REG.NC=0 AND REG.DEG_CODE=205

    REG_CODE=205 , "Dr." REG.NC , 0 = , 2 = .

    / . (WHERE REG_CODE=205)

    ? .
    (tot/native)*100


    , Access.

    !
    !



    : , , .

    , , .
    Last edited by Darknauss; 13th May 2016 at 20:40.

  2. #2
    Banned all's Avatar
    Join Date: Feb:2003
    Location: Sofia
    Posts: 6,980
    , - !
    .

  3. #3
    Darknauss's Avatar
    Join Date: Mar:2005
    Location: Sofia/Vienna
    Posts: 2,151
    , o VB .

    , , , (rubber duck debugging):
    1 4 , 2 - - (2005/6/7), (101/102/103/104)
    o . .

    2 4 , =1., 2007,2006,2005, , .

    2005- , 2, "operation must use an updateable query".

    , ,

  4. #4
    Banned all's Avatar
    Join Date: Feb:2003
    Location: Sofia
    Posts: 6,980
    update .
    - .


    , , , , , .

  5. #5
    Darknauss's Avatar
    Join Date: Mar:2005
    Location: Sofia/Vienna
    Posts: 2,151
    , , "operation must use an updateable query"
    , .

    UPDATE TRANS_YER, TASK7_Y2005
    SET TRANS_YER.Y2005 = [TASK7_Y2005].[COUNT]
    WHERE (((TASK7_Y2005.CODE)=[TRANS_YER].[DEG_CODE]));

    , :

    Click image for larger version. 

Name:	TRANS_YER.PNG 
Views:	30 
Size:	4.5 KB 
ID:	82731Click image for larger version. 

Name:	TRANS.PNG 
Views:	22 
Size:	13.0 KB 
ID:	82730

    :

    SELECT TRANS.DEG_CODE AS CODE, Count(TRANS.DEG_CODE) AS [COUNT]
    FROM TRANS
    WHERE (((TRANS.DYEAR)=2005))
    GROUP BY TRANS.DEG_CODE;

    2005 >
    Last edited by Darknauss; 14th May 2016 at 11:07.

  6. #6
    Banned all's Avatar
    Join Date: Feb:2003
    Location: Sofia
    Posts: 6,980
    . - , . .
    , ( ). , .
    , , , query- .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |