.


:

:



,



( , )

:

































 

 

 

 
FAQ

⇐ 1234 ⇒



. , .

, , . . (, ) , , . :

(, , , , , , )

, . :

(, , , , , )

: . ( ), , -, ( , ), - :

(, , , , , )

, , . :

_ (, , , , , , , , , )

: ,

, . , , , .

Microsoft Access

Microsoft Access .

:

8

4

2

20

/ 8

/ 8

:

4

50

/ 8

1

2

50

:

4

50

1

2

20

4

4

:

4

/ 8

4

50

/ 8

/ 8

4

4

4

8

. 2.

. 2.

, , .

.
83777 -2404     29.11.08
09377 -2404     03.11.08
39877 -3110     16.10.08
38677 -2410     23.09.08
86577 -2410     03.12.08
87477 -2410     31.10.08
98377 -2404     17.11.08
34177 -3110   27.02.08 03.10.08
71277 -2404   03.08.08 04.11.08
40277 -2410     17.10.08
87677 -3110   25.09.05 27.10.08

 

.
  13.02.65 B   87677
  12.11.55 C   38677
  03.02.72 B   86577
  03.06.68 C   83777
  13.02.82 B   98377
  21.10.78 C   87477
  12.04.59 C   87477
  07.08.78 B   40277
  04.11.64 D   71277
  05.08.82 B   09377
  17.04.56 D   34177
  23.07.81 B   39877
  30.03.67 C   87677
  25.08.63 C   39877
  19.03.77 B   83777

 

100
  -3110     10,2  
  -2410     9,6  
  -2404     10,7  

 

:
  04.12.08 87677 6:30 13:50       750,00.
  04.12.08 38677 6:55 14:25     10,2 630,00.
  04.12.08 83777 7:20 16:10     9,5 588,00.
  04.12.08 87677 14:20 22:55       930,00.
  04.12.08 83777 16:50 23:45       810,00.
  04.12.08 40277 8:15 15:55       588,00.
  05.12.08 71277 7:30 14:45     9,8 720,00.
  05.12.08 98377 7:35 14:55       990,00.
  05.12.08 09377 8:12 15:54     11,8 888,00.
  05.12.08 86577 9:16 17:00       900,00.
  05.12.08 87677 7:25 15:10       990,00.
  05.12.08 83777 12:40 20:45       1 050,00.
  14.12.08 87477 8:10 16:45       870,00.
  14.12.08 87477 8:25 17:10       1 050,00.
  14.12.08 34177 10:40 18:55       1 104,00.
  14.12.08 39877 11:00 19:30       1 200,00.
  14.12.08 39877 20:00 5:00       630,00.
  15.12.08 83777 7:30 15:20       570,00.
  15.12.08 40277 7:55 16:00       870,00.
  15.12.08 86577 7:57 16:00       750,00.
  15.12.08 39877 8:00 16:10       1 050,00.
  15.12.08 71277 8:05 15:55     9,8 720,00.
  15.12.08 87677 8:05 15:45     16,5 1 050,00.
  15.12.08 87477 8:05 15:50     14,5 1 080,00.
  15.12.08 98377 8:10 16:30       1 260,00.
  15.12.08 39877 16:45 23:55       1 170,00.
  15.12.08 87677 16:35 0:40       1 260,00.
  15.12.08 38677 16:35 0:35     11,7 810,00.
  15.12.08 87477 16:40 0:55       1 110,00.
  15.12.08 34177 16:40 1:20       1 380,00.
  15.12.08 83777 16:45 1:20     15,6 1 050,00.
  15.12.08 09377 17:00 1:50       1 230,00.

, , .

( ) . SQL:

SELECT ., ., ., ., !+! AS [ ]

FROM INNER JOIN ON . = .

ORDER BY !+!;

. 3.

:

.
38677 -2410   23.09.08 22.12.08
34177 -3110   03.10.08 01.01.09
39877 -3110   16.10.08 14.01.09
40277 -2410   17.10.08 15.01.09
87677 -3110   27.10.08 25.01.09
87477 -2410   31.10.08 29.01.09
09377 -2404   03.11.08 01.02.09
71277 -2404   04.11.08 02.02.09
98377 -2404   17.11.08 15.02.09
83777 -2404   29.11.08 27.02.09
86577 -2410   03.12.08 03.03.09

. , , , , ( ) , . SQL:

SELECT ., Max([ ].) AS

FROM ( INNER JOIN ON . = .) LEFT JOIN [ ] ON . = [ ].

WHERE (((.)=[Forms]![ ]![]))

GROUP BY .;

. 4.

, , .

: , , . , . SQL:

SELECT Max([ ].) AS

FROM [ ]

WHERE ((([ ].)=[Forms]![ ]![]));

. 5.

, , .

. SQL:

SELECT ., ., Avg([ ].) AS [ ]

FROM INNER JOIN [ ] ON . = [ ].

GROUP BY ., .

ORDER BY Avg([ ].) DESC;

. 6.

:

D 1 242,00.
B 1 185,00.
B 1 125,00.
C 1 095,00.
C 1 065,00.
B 1 059,00.
C 990,00.
B 970,00.
B 930,00.
C 840,00.
B 825,00.
B 729,00.
C 720,00.
D 720,00.
C 579,00.

. ; , .

, , , . SQL:

SELECT ., ., Count([ ].) AS , Sum([ ]!-[ ]!) AS , Sum([ ].) AS [ ], Sum(([ ]!-[ ]!)*!/100) AS [ ], [ ]-[ ] AS

FROM INNER JOIN ( INNER JOIN [ ] ON . = [ ].) ON . = .

WHERE ((([ ].)>=[Forms]![ ]![] And ([ ].)<=[Forms]![ ]![]))

GROUP BY ., .;

:

.
83777 -2404     63,1000003814697 69,0149987697601 -5,9149983882904
09377 -2404     28,8000001907349 29,9599994659424 -1,15999927520752
39877 -3110       47,9399991035461 22,0600008964539
38677 -2410     21,8999996185303 18,2400007247925 3,65999889373779
86577 -2410       22,3680008888245 3,63199911117554
87477 -2410     56,5 51,8400020599365 4,65999794006348
98377 -2404       29,5319994735718 0,46800052642822
34177 -3110       27,5399994850159 13,4600005149841
71277 -2404     19,6000003814697 21,7209996128082 -2,1209992313385
40277 -2410       26,7840010643005 1,21599893569946
87677 -3110     81,5 67,8299987316132 13,6700012683868

. 7.

, , . SQL:

. 8.

SELECT ., Count([ ].) AS , Sum([ ]!-[ ]!) AS , Sum([ ].) AS [ ], Sum([ ].) AS [ ]

FROM INNER JOIN [ ] ON . = [ ].

WHERE ((([ ].)>=[Forms]![ ]![] And ([ ].)<=[Forms]![ ]![]))

GROUP BY .

ORDER BY .;

:

    20,5 1 158,00.
      1 458,00.
      1 650,00.
      1 680,00.
    19,6000003814697 1 440,00.
    50,5 2 790,00.
    30,5 2 130,00.
      2 250,00.
      2 370,00.
      2 190,00.
    21,8999996185303 1 440,00.
      1 980,00.
      2 484,00.
    42,6000003814697 2 910,00.
    28,8000001907349 2 118,00.

, , 100 , ( 100 ). SQL:

SELECT ., Count(.) AS , ., Sum([ ]!-[ ]!) AS , Sum([ ].) AS [ ], [ ]/[]*100 AS [ ]

FROM INNER JOIN ( INNER JOIN [ ] ON . = [ ].) ON . = .

WHERE ((([ ].)>=[Forms]![ ]![] And ([ ].)<=[Forms]![ ]![]))

GROUP BY ., .;

. 9.

:

100
-2404   10,7   141,500000953674 10,0783476462731
-2410   9,6   132,39999961853 10,66022541212
-3110   10,2   192,5 13,7010676156584

⇐ 1234 ⇒


:

: 2017-01-28; !; : 494 |

:

:

: , .
==> ...

2218 - | 1834 -


© 2015-2024 lektsii.org - -

: 0.043 .