Results 1 to 7 of 7
Thread: MS ACCESS
Hybrid View
-
13th May 2016 20:12 #1
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.
-
13th May 2016 21:50 #2
-
13th May 2016 22:16 #3
, 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".
, ,
-
14th May 2016 09:03 #4
-
14th May 2016 10:48 #5
, , "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]));
, :
:
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.
-
14th May 2016 21:30 #6




Reply With Quote
.
Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in