5
1) : 1 , . : .
: | |||||
_ | _ | : Year(Date())-Year([]![ ]) & "" & Month(Date())-Month([]![ ]) & "" & Day(Date())-Day([]![ ]) & "" | |||
: | |||||
:
SQL:SELECT ._, ._, .[ ], .[ ], Year(Date())-Year([]![ ]) & "" & Month(Date())-Month([]![ ]) & "" & Day(Date())-Day([]![ ]) & "" AS
FROM ;
3) : 3 . .
: | |||||
_ | _ | : !_ & " " & Format(![ ];"d\ mmmm\ yyyy") & " - " & Format(![ ];"dddd") | |||
: | |||||
:
SQL:SELECT ._, ._, .[ ], !_ & " " & Format(![ ],"dmmmmyyyy") & " - " & Format(![ ],"dddd") AS [ ]
FROM ;
: | ||||||||
_ | _ | ( ) | () | : Date()-![ ] | : ![ ( )]*30 | : IIf([ ]>[ ];"";IIf(([ ]-[ ])>=0 And ([ ]-[ ])<=5;0,5*[]![ ()];0)) | ||
: | ||||||||
4) : , , : 5 50% , .
|
|
: , ,
SQL:SELECT ._, ._, .[ ], .[ ( )], .[ ()], Date()-![ ] AS [ ], ![ ( )]*30 AS [ ], IIf([ ]>[ ],"",IIf(([ ]-[ ])>=0 And ([ ]-[ ])<=5,0.5*[]![ ()],0)) AS
FROM INNERJOIN ( INNERJOIN ON ._ = .[ ]) ON ._ = .[ ];
5) : 5%, 5%. , $ . .
: | |||||||||
_ | _ | () | ( ): IIf(![ ]=0;[ ()]*0,5+[ ()];[ ()]*0,5) | ($): [ ( )]/[ $] | ( Euro): [ ( )]/[ Euro] | ||||
: | |||||||||
: ( ), ($). ( Euro)
SQL:SELECT ._, ._, .[ ()], .[ ], .[ ], IIf(![ ]=0,[ ()]*0.5+[ ()],[ ()]*0.5) AS [ ( )], [ ( )]/[ $] AS [ ($)], [ ( )]/[ Euro] AS [ ( Euro)]
FROM INNERJOIN ( INNERJOIN ON ._ = .[ ]) ON ._ = .[ ];
2) :
: | |||||
: | |||||
:
SQL: