Standard Jet DBnb` Ugr@?~1y0̝cßFN n7ќL(#`{6߱aCE:3y[ |*|,(y5f_Љ$g'DeFx -bT4.0dv  YAS MM Y   Y Y  Y Y  Y  Y  Y  r Y s Y E Y a Y d Y 2Y  Y   Y  jY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeni    YYIdParentIdName        OYSLY Y Y  Y 2ACMFInheritableObjectIdSIDY YObjectId YSMY  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttribute -YSY Y Y  Y  Y  Y  Y  Y tccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship               YYYszObject$szReferencedObjectszRelationshipYv1b N  : k & W  C t/  @@H   @ @@@  @@    @@@  kf[JO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+Skf[ +m`fM^fH:<<8 86fQxxYSdibYmYOJYSdibYmdiYOY^dbOiJJYfidUQmmYOY^dbOiJ>88MdffYQMYmmJmM8SdibOQ^^J8JSdibYkMJfQxxYJfi[OQ^^J:J>8:bOMOYfQxxYSdibYmYJfi[OQ^^JkmQkkJMYmmJ> 88>mommQ^QMdffYQOYbOMOQYfQxxYmJ^YMWQhoJ^MWQSdibYmdiQ>8@bo`QidmdmJ^QOYfidUQmmYSdibYmYOJk8>8BhoJbmYmJmdmJ^QOYfQxxYf8SdibYmYOJk8> 8D8FbOMOQYfQxxYSdibYmYJhoJ^MWQfidUQmmdYbJqU`JUUJ<:6> 8HSdibYmoiQ^JMoYhoJbmYmJbdbQbo^^> 8midqJiQmommYYOQmmJU^YOYmommYYfidUQmmY :6bOMQ^QMYmmJOQYfidUQmmYuYhoJ^Y^JMYmmJWJobJd> :8bd`YOQYfidUQmmYSdibYmYOJk8>::Md^diYOQYfQxxYSdibYmYOJk8>::>bOMfidUQmmYMWQomY^YxxJbdJ^`QbdobfQxxdSdibYLY^QOJk8>:@bOMOQYSdibYmdiYMWQSdibYkMdbdJ^`QbdobfQxxdSdibYmd>:BbOMOQYSdibYmdiYJqQbmYkmJmok`YbdiQOYhoQ^^dOYk8>:DbOMfidUQmmY^JMoYMYmmJQ^J8JYbdiOYbQJ^SJLQmYMd>:FbOMfi[SdibYmYMbY^f8Ybhmv`QOYJ`QOYJ`JUUYdiQ`Jufi[[8:midqJiQmommYYOQmmJU^YOYmommYYfidUQmmYYb^dbOiJ <6bOMOQYfQxxYSdibYmYJfidUQmmYOY^dbOiJMdbQuYkmk<8bOMOQYfidUQmmYMWQomY^YxxJbdJ^`Qbd8fQxSdibYLY^QOJk8Qu<:bOMOQYfidUQmmYbbSdibYmYMdbfQxxYidkkYOJYSdibYmdiY^db><bOMOQYfQxxYSdibYmYJmommYYfidUQmmYOY^dbOiJ<@bOMSdibYmdiYMWQSdibYkMdbd^dkmQkkdfQxxdJmommYYfi[midqJiQmommQ^QSdibYmoiQOY8hoJbmYmJMd`fiQkJmiJ<66QD@6  @Md`LMd^diQOQ^fQxxdMYmmJOQ^fQxxdkQbxJOof^YMJxYdbY 7Co{!BSdibYmdiQfQxxdfi[MWQkYJbdbQ^^JkmQkkJMYmmJ "DSdibYmdiQfQxxdfi[MWQkYJbdbdbbQ^^JkmQkkJMYmmJ #FSdibYmdiQfQxxdfi[MWQkYJbdYbMYmmJOYqQikQ >HmidqJiQYfQxxYSdibYmYOJYSdibYmdiYOY^dbOiJ >[>`kvkJMMQkkdL[QMmk`kvkJMMQkku`^`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkfkkf[JMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOfkf[kkf[  @ @ @ @ @ @ @ @          !"#>>>>> > > > > >> >!>">#>$>%>&>'>(>)*+,-./0 1 2 3#0N>* @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @+++++++++ + + + +++++++++++++$+% +/ +0 +1 +2 +3 +4 +) +* ++ +, +- +... . .................. .!.".#.$.%.&.'.(.).*.+.,+Z+[+\+]./.0.1.2.3.4.5.6.7.8.9.:.;.<.=.>.? .@ .A .B!.C!.D!.E".F".G".H#.L#.M#.N$.O$@$@%@%@%@&@&@&@'@'@ '@ (@ (@ (@ )@)@)@*@*@*@+@+@+@,@,@,@-@-@-@.@.@.@/@$/@%/@&0@*0@+0@,0@-1@11@21@32@42@52@63@:3@;3@<+?+@+A+B+<+=+>+C+D+E+F+G+H+8+9+:+;+I+J+K+L..#.#.#.0. 0. 0. 0.N+TN+UN+V++++ ++ ++++!+"+#B9 =           &$#%'.-+,(/0kl99999999 9 9 9999 9 9999999999"9 9!9#99$98959694979%999E9B9C9A9D9: 9F 9R 9O 9P 9N 9Q 9G!9S!!!!9T"9]"9p"9n"9m"9o"9^#9s#9x#9w#9y#9t$9z$9$9$9$9{%9%9%9%9%9%9%9%9&9&9&9&9&9&9&9&9'9'9'9'9'9'9(9((9((9)) ) ) ) )* ****++ ++!+,",#9 @fkf[*kkf[*kkf[* kf[*kf[*kf[*f*k*k*!$d _ Z g  ~ ) y y ~--GHw\F&w@\F&w@\F&w@5@7-FORNIT\F&w@5@7-FORNITORE PEZZO PRJ CHE SIANO NON\F&w@5@7-FORNITORE PEZZO PRJ CHE SIANO NON NELLA STESSA CITTA'b@C`@, `d(@Uߞ@6-FORNITORE PEZZO PRJ CHE SIANO NELLA STESSA CITTA'@7`@, @t@P@5-comb colore-del-pezzo citt-del-pezzo senza duplicazioni7@5@;7`@ , `Y@K@4-Trovare tutte le forniture di 1 quantit compresa tra300e750@*7`@, @]d@S@3-NdC fornitori ke forniscono pezzi al prj J1 ordinati BY NdC@7`@, @VPW@4@2-Trovare tutti i dettagli di tutti i progetti in Londra@7`@, @0iJ@iJ@MSysAccessXML4MR2KeepLocal  T|||<<<<<<<: @iJ@r@1-Trovare tutti i dettagli di tutti i progetti@5@-`@/~~~~~~| ` L @L @SSPJ**********(  cM @cM @PSPJ**********( # @I/ @SPJ@-444(((((((& @Q% @/ @S@-000$$$$$$$" @gX- @-. @PJ@-000$$$$$$$" @Ԭ2^Y@>g3^Y@MSysAccessObjectsDDDDDDDDDDB  sNQ @FG#Q @17o@-@,>22&&&&&&&$ @  U @62@Admin`@ A8,,,,,,,,,*  bԷ @bԷ @UserDefined88888888886  :aԷ @:aԷ @SummaryInfo@-DDD88888886 @ S ^ @&v@AccessLayout4MR2KeepLocal T"@Dzz:::::::8 @oeԷ @oeԷ @SysRel.........., oeԷ @oeԷ @Scripts0000000000. oeԷ @oeԷ @Reports0000000000. oeԷ @oeԷ @Modules0000000000. oeԷ @oeԷ @Forms,,,,,,,,,,* "^Y@"^Y@DataAccessPages@@@@@@@@@@> _Է @_Է @MSysRelationshipsDDDDDDDDDDB _Է @_Է @MSysQueries88888888886 _Է @_Է @MSysACEs22222222220 _Է @_Է @MSysObjects88888888886 _Է @"^Y@MSysDb"@-:::......., @_Է @_Է @Relationships<<<<<<<<<<: _Է @_Է @Databases44444444442 _Է @_Է @Tables.........., Q#ΉkM- z \ > g I + +++++ x Z < <<  a aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaC % %%%%%%%%%%%%%%%%%%%% M ) Ma7}Y9uuuuuuuuuuuuuA!yyyyyyyyyyyyyyyyE%{]]]]]]]]]]+kMMM/NDP.[P#]% g   G GF@ < 'SPJ J S J.CITY% gS.CITY% g  G G@ < 'SPJ J S  SPJ.[P#]' g Au Au G GF@< 'SPJ S  SPJ.[P#]' g6J4 J4 G G@< 'S J P SPJ  SPJ.[J#]' g SPJ.[P#]' g SPJ.[S#]' g G@< 'S J P SPJ  SPJ.[J#]' g SPJ.[P#]' g SPJ.[S#]' gY GTY@< 'TYS TYJ TYP TYSPJ Y SPJ.[J#]' gY SPJ.[P#]' gY SPJ.[S#]' gTY Y G   Gtt t G GP CITY# gCOLOR$ g    G GQTY>=300 AND QTY<=7504 'SPJ [P#]# g  G [J#]# ' [J#]='J1'( 'SPJ [S#]# gord rd G:L G:LCITY='LONDON', ':LJ :L :L G Gj   G  spj.jn=j.jn* '  spj.qty& g j.pn# g pn! g spj" g j  spj     Gxkkkkkk;ΗgC c cccccc3  ̭} ] 9  w wwwwwwwwwwY ; ;;;;;; ʽʟ c E EEEEEE' ɝ y I  ȳ|X(tD/ @ '/ [J#]# g/ [P#]# g/SPJ /[J#]# g3 [P#]# g3 [S#]# g3SPJ 3 COUNT([J#])* g3e 3 G- @ '- [S#]# g- [P#]# g-SPJ -[S#]# g2 G2 G2cZ 2Z G1  G1  G1  1  G0SPJ 0  G0 0 G/ Au /Au G- Au -Au G, U@ ', ([P#])% g,UF@ ',USPJ ,UJ ,[P#]# g, Au ,Au G+abl@ '+ablJ +bl[J#]# g+  +  G* @6 '* J *[J#]# g!n@ '!SPJ ![J#]# g*  *  G) G)@-< ')P )[P#]# g)  )  G( [S#]='S1'( '(SPJ 9b R R C33kg])@vuD@37-numero totale di progetti forniti da ciascun fornitore@`@L @2ɨ@@38-nomi dei fornitori che forniscono pezzi che nessun altro FORN@m`@G @1;@'FI@~TMPCLP92331@T`@LRFF:::::::8 @05ǭ@+}6ǭ@~sq_fSPJn @H4MR2KeepLocal T~~~>2222220 `/>^ @)׋ͳ@28-NdC prj forniti cn ilP1 in qty media media maggiore maxprj j1@`@U @.I@I@SPJ((((((((((& -"@槚@35-NdC fornitori che forniscono lo stesso pezzo a tutti i prj@`@U @,J7@}@34-NdC dei pezzi forniti a tutti i progetti di Londra@4`@: @+y-ӂ@S0@33-NdC dei progetti forniti interamente dal fornitore S1@$`@: @*{F@6l@31-NdC dei progetti che utilizzano almeno 1 pez fornibile daS1EX@ `@: @)̇ @[)@30-NdC dei pezzi forniti a progetti di Londra CON EXISTS@?`@G @r LVAL X [P#]='P1' AND AVG(QTY) > ( SELECT MAX(QTY) FROM SPJ WHERE [J#]='J1' )COUNT([J#])= ( SELECT COUNT([J#]) FROM J )COUNT(J.[J#])= ( SELECT COUNT ([J#]) FROM J WHERE CITY='LONDON' )J.[J#]=SPJ.[J#] AND J.CITY='LONDON'NOT EXISTS ( SELECT * FROM SPJ WHERE SPJ.[J#]=J.[J#] AND [S#]<>'S1' )[P#] IN ( SELECT [P#] FROM SPJ WHERE [P#] IN ( SELECT [P#] FROM SPJ WHERE [P#] IN ( SELECT [P#] FROM SPJ WHERE [S#]='S1' ) ) )LVAL ̼ ˼˼˼˼˼˼˼˼˼˼˼˼˼˼˼˼˼˼˼˼˼˼˼˼˼˼˼˼˼˼˫ ʫʫʫʫʫʫʫʫʫʫʫʫʫʫʫʫʫʫʫʫʫʫʫʚ ɚɚɚɚɚɚɚɚɚɚɚɚɚɚɚɚɚɚɚɚɚɚɚɚɉȉȉȉȉȉȉȉȉȉȉȉȉȉȉxxxxxxxxxxxxxxxxxxxxxxxxxnjMR2RecordLocksOMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultView:  <   MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultView:  <   MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <     YNY Y DataIDYAOIndexv1 K[fX <XV SysAccessObjects6LLLLLLLLLLJ ] @^ @l^ @TYD0& D0& . ^ @-N@T_  WJx   P@ #  3G xH  x K[ࡱ> Root Entry ؍3'@&VBA&XPՍ3VBAProjectm;XPՍ3VBAuoXPՍ3&)  " !#$*%(,+/-.01DataAccessPages &X&X0m}X3؍3DirData5Blob @8f   !"#$%&'()*+s./01S89:<=>?ABCDEFGHIJKLMNOPQpqrtuvwxyz{|}~TypeInfo;,BlobDelta7PropData6 PropDataR Access 11.0 Object Library*\G{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL#Microsoft DAO 3.5 Object Library*\G{00020430-0000-000K[0-C000-000000000046}#2.0#0#C:\WINDOWS\System32\stdole2.tlb#OLE AutomationP*\G{0002E157-0000-0000-C000-000000000046}#5.3#0#C:\Programmi\File comuni\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB#Microsoft Visual Basic for Applications Extensibility 5.3 YBx $AccessVBAWin16~Win32MacVBA6#spjDAOstdole`VBIDEAH   ID="{A87D8758-1742-45E2-8FE7-99A45DC27A6B}" Name="spj" HelpContextID="0" VersionCompatible32="393222000" CMG="2527CC35D45ED85ED85ED85ED8" DPB="4A48A314C915C915C9" GC="6F6D86738EBDB2BEB2BE4D" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E4DataAccessPages &X&X0m}X3m}X3DirData5Blob @fAcessVBAData2 Forms  &X&XCmdbars&X&XModules &X&XReports&X&XScripts &X&XPropData3Databases&X@ɗX0&XWXBlob DirData4CustomGroups&X&X  !"#$%&'()*+-./089:<=>?ABCDEFGHIJKLK[MNOPQRoot Entry PՍ3'@&VBA&XPՍ3VBAProjectm;XPՍ3VBAuoXPՍ3  )"& !#$*%(,+/-.01AcessVBAData2 Forms  &X&XCmdbars&X&XModules &X&X  !"#$%&'()*+s./01S89:<=>?ABCDEFGHIJKLMNOPQpVWXY[\]_`abcdefghijklmnoqrtuvwxyz{|}~" GC="4341AAEB6AEC6AEC95" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [WorkspaijMSysDb SPJdefghijk3-00A0C911005A};VBE;&H00000000 [Workspace] ijMSysDb SPJdefghijkBlobCopy^fBlobDeltaCopyZTypeInfoCopyUPropDataCopy, lmnoprz{mdmdmdmdͬ  @EIJKfYN Y d Y d Y dY  Y dP# PNAME COLOR WEIGHTCITYYPrimaryKeyv1@ W. P7CAZZBLACKNEW GUINEA# P6DogRedLondon  P5CamBlueParis P4ScrewRedLondon P3ScrewBlueRome P2BoltGreenParis  P1NutRedLondon   @f8f:f<f>f@fBfDAYN   Y d Y dY  Y dS# SNAME STATUSCITYS "YPrimaryKeyv16rNS5AdamsAthens S4ClarkLondon S3BlakeParis  S2JonesParis S1SmithLondon   k8!k:!k<!k>!k@! iYN$$ Y d Y d Y dY S#P#J#QTY$&$'$($)YYYYYPrimaryKey SPJJ# SPJP# SPJS#Hv1b@  #oR5jM0 e H + AS5P7J4  S1P1J8 SP1J3 S5P6J4 S5P6J2 dS5P5J7 S5P5J5 S5P5J4  S5P4J4 S5P3J4 dS5P2J4 S5P2J2 dS5P1J4 ,S4P6J7 ,S4P6J3 S3P4J2 S3P3J1 dS2P5J2  S2P3J7 S2P3J6 XS2P3J5 S2P3J4 S2P3J3 S2P3J2 S2P3J1 S1P1J4 S1P1J1 E #@ @ @ k8f8[8%k8f8[>%k:f<[8%k:f<[:%k:f<[<%k:f<[>%k:f<[@%k:f<[B%k:f<[D%k:f@[:% k<f<[8% k<f>[:% k>fB[<% k>fB[D% k@f8[>%k@f:[:%k@f:[>%k@f<[>%k@f>[>%k@f@[>%k@f@[@%k@f@[D%k@fB[:%k@fB[>%k@fD[>%? # @ @ @[8%[8%[8% [:%[:% [:% [:%[:%[<%[<% [>%[>%[>%[>%[>%[>%[>%[>%[>%[@%[@%[B%[D%[D% [D%? # @ @ @f8%f8%f8%f:%f:%f<%f<%f<%f<%f<%f<%f<%f<% f<%f>% f>%f@% f@%f@%f@%fB% fB% fB%fB%fD%? # @ @ @k8%k8%k:%k:%k:%k:%k:%k:%k:%k:% k<% k<% k>% k>% k@%k@%k@%k@%k@%k@%k@%k@%k@%k@%k@%SSPJSPJS#SS#&" SSPJSPJS#SS#&" PSPJSPJP#PP#&"  ^vcP=*z @ -  } j C 0  m Z G ɪɪɗ p]I6666#"! p]I6########s  ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp  N N˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp N   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp  @˙ѷ^3wMEm)W>r.3 aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp  T˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp  T˙ѷ^3wMEm)W>r.3 aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp T˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp  ˙ѷ^3wMEm)W>r.3 aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp  ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp     ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp      ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp      ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp      ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp     ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp    ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp     ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp    ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp    ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp     ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp    ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp     ˙ѷ^3wMEm)W>r.3 aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp  vLVALX ͘ ̘8 8 xάb9άY ά άYάY ά άY άb9 ά% Z. άm άb9  LVAL.TΛ ěěěěěěįïODBCTimeoutMaxRecords FilterOrderByMR2ZRecordLocksODBCTimeoMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultView:  <   MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultView:  <   MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultView:  <   MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultView:  <   MR2AccessVersion Build6Track Name AutoCorrect Info0Perform Name AutoCorrectProjVerCpgConversionZ 08.50 c   # MR2ValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlDecimalPlaces M S#       mM P#       mM J#       mY QTY g     0   mMR2ValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlDecimalPlaces M S#       mS SNAME       m_ STATUS      0   mQCITY       mMR2ValidationRuleValidationText FilterOrderByOrderByOnColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlDecimalPlaces M P#       mS PNAME       mS COLOR       m_ WEIGHT      0   mQCITY       mMR2LRecordLocksODBCTimeoutMaxRecords  <MR20 Title AuthorCompanyx spj, $Laboratorio CCLINF2 *Politecnico di Torino6PvcO<) (  x  d Q > *   z g S@-Ǐ|iUB/~kXD1 $ # #˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp # " "˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp " ! !˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp !    ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp    ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp  ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp   ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp  0˙ѷ^3wMEm)W>r.3 aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp 0 0˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp 0  ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp  # #˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp #  ˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp LVALРΠΠΠΠΠΠΠ@ @ ˀ άb9 ʾSPJά(bI ά(bI ά`C άb9 άb9 άb9 S Y N11Y   Y <Y K Y @ Y ,m Y mKId LValueObjectGuidObjectNameProperty Value,Km,Km,12mK,Km,Km,13mK,Km,Km,14mK,YYYId$ObjectGuidProperty$ObjectNameProperty1Hv1b 0 0 0LVAL_(hDt7$  ? ttt t    d F ( o Q 3 3333 x Z < <<<<<<<<<<<<<<  a C CCCCCC h J JJJJJJ pRRRRRRRRR4zzz\>>>ƈƈƈƈX8~Z:ĶĄR,~`````````````````````````````````````````````````````````0ŒT((COUNT(COUNT ([J#])+(COUNT ([J#](COUNT ([J#])+ g( ( G' G'@+< ''J '[J#]# g' ' G& G&"a.[s#]=b.[s#] and a.[p#]<>b.[p#]? '&spjb &spja &b.[p#]% g&a.[p#]% g& Au &Au G% G%l@< '%j %spj %s % spj.[j#]' g% % G$X@< '$J $[J#]# g$ $ G#@< '#S #[S#]# g#  # G" G" @< '" SPJ "[S#]# g" Au "Au G!  ! G  G F@< ' SPJ  J  [P#]# g `\  `\ G GB@< 'P SPJ COLOR$ g   GN GNB@< 'NJ NSPJ NJNAME$ g  G CITY LIKE '*O*'. ' J  CITY# g [J#]# g  G QTY<>NULL( 'SPJ [P#]# g[S#]# g  G AVG(QTY)>320+ ' [P#]# gSPJ [P#]# g  G[s#]='s1' and [p#]='p1'6 'spj  sum (qty)( g  GND GNDj@< 'NDS NDSPJ NDJ NDP LVALР@ @@@@@@ ʀ ``άNI ʾSPJά_9 ά  ά άwY8 άa ά~~ άaI ά- άt9 άNI  LVAL .H".P".d".( @.|". !.".x".".!. d@. d@. d@ H.. #."...#.#.#.( P.$. P#.,$.$.$.@#. dP. dP. d@ H.. $.8$...X%.`%.t%.( .%. $.%.%.%.$.P..p.%.%.%.0&.`.@LVAL3 Ff f ͎ H HHHH Z Z d  zzĴ´´´´EXISTS ( S[PAVG(QTY) > ( SELECT MAX(QTY) FROM SPJ WHERE [J#]='J1' ) AND EXISTS ( SELECT [P#] FROM P WHERE P.[P#]=SPJ.[P#] AND [P#]='P1' )EXISTS ( SELECT * FROM SPJ WHERE P.[P#]=SPJ.[P#] AND [J#] IN ( SELECT [J#] FROM J WHERE CITY='LONDON' ) )NOT EXISTS ( SELECT * FROM SPJ WHERE [J#]=J.[J#] AND [P#] IN ( SELECT [P#] FROM P WHERE COLOR='RED' AND [S#] IN ( SELECT [S#] FROM S WHERE CITY='LONDON' ) ) )s.[s#]=spj.[s#] and j.[j#]=spj.[j#] and j.city<>s.cityCITY<= ( SELECT MIN(CITY) FROM J )STATUS < ( SELECT STATUS FROM S WHERE [S#]='S1')[P#] IN ( SELECT [P#] FROM SPJ WHERE [S#] IN ( SELECT [S#] FROM SPJ WHERE [P#] IN ( SELECT [P#] FROM P WHERE COLOR='RED' ) ) )SPJ.[J#]=J.[J#] AND J.CITY='LONDON'P.[P#]=SPJ.[P#] AND SPJ.[S#]='S1'SPJ.[J#]=J.[J#] AND SPJ.[S#]='S1'P.[P#]=SPJ.[P#] AND J.[J#]=SPJ.[J#] AND S.CITY=J.CITYs.[s#]=spj.[s#] and j.[j#]=spj.[j#]SPJ.[J#]=J.[J#] AND S.[S#]=SPJ.[S#] AND J.CITY='LONDON' AND J.CITY=S.CITYS.[S#]=SPJ.[S#] AND S.CITY='LONDON'P.[P#]=SPJ.[P#] AND J.[J#]=SPJ.[J#] AND S.[S#]=SPJ.[S#] AND (J.CITY<>P.CITY OR P.CITY<>S.CITY OR J.CITY<>S.CITY)P.[P#]=SPJ.[P#] AND J.[J#]=SPJ.[J#] AND S.[S#]=SPJ.[S#] AND J.CITY=P.CITY AND P.CITY=S.CITY AND J.CITY=S.CITYP.[P#]=SPJ.[P#] AND J.[J#]=SPJ.[J#] AND S.[S#]=SPJ.[S#] AND J.CITY<>P.CITY AND P.CITY<>S.CITY AND J.CITY<>S.CITYB @ @ @ @ @ @ @ @ @ @ @ @ @ @             &$#%'.-+,(/0kl99999999 9 9 9999 9 9999999999"9 9!9#99$98959694979%999E9B9C9A9D9: 9F 9R 9O 9P 9N 9Q 9G!9S!!!!9T"9]"9p"9n"9m"9o"9^#9s#9x#9w#9y#9t$9z$9$9$9$9{%9%9%9%9%9%9%9%9&9&9&9&9&9&9&9&9'9'9'9'9'9'9(9((9((9)) ) ) ) )* ****++ ++!+,",#9?= ́  J ?CCz,(j @{c @(j @4" @15-numero totale di progetti forniti da S1@?`@ :vvvvvvvt @'@@32-NdC dei progetti nn forniti con pezzi rossi dai fornitori LONL@F@?`@ : `&@hZ@14- tutte le coppie di NdC dei pezzi tali che qualche fornitore@V?`@: @%@0˱@13-NdC dei progetti forniti da almeno1fornitore stessa citta@F?`@/ @$%ڛ@N@27-NdCprogetti la cui citt la 1A in ordine alfabetico@??`@/ @#oc@Ky@26-NdC dei fornitori aventi STATUS minore di quello di S1@'?`@ / @"@ @^y=@25-NdC dei fornitori che forniscono almeno un pezzo fornito---@C`@ / @!R@ǁ~@24-NdC progetti che utilizzano almeno un pezzo fornibile da S18E]@ `@: ` ެ7@@23-NdC dei pezzi forniti a progetti di Londra@C`@:|||||||z @G,@@22-colori dei pezzi forniti da S1@C`@A|ppdddddddb @|4o@/|@21-nomi dei progetti forniti da S1@yC`@A~rrfffffffd @ @HL@20-NdC e le citt dei progetti x i quali la citt ha una O@ZC`@A @84@84@19-forniture la cui quantit non e NULL@KC`@A||pppppppn @Q6@Q6@18-NdC dei pezzi forniti a qualche progetto in AVG MAGG a 320@--`@A @(@@16-quantit totale di pezzi P1 forniti da S1@(-`@Azzzzzzzx @n@n@12-NdC di pezzi forniti a prj della stessa citt@BC`@ A @Nq@@ ]B@Jy@C000$$$$$$$" @w9@%3y@11-COPPIE CITTA TC 1 FORN DELLA 1A FORNISCA PEZZI A PRJ DELLA 2A@C`@ A @lR@k|@10-pezzi forniti dai fornitori di Londra ai progetti di Londra @a@C`@A `Z@Eo@9-Trovare i pezzi forniti dai fornitori di Londra@7`@A @@@8-FORNITORE PEZZO PRJ CHE SIANOIN CITTA' DIVERSEc}@-`@, `LVAL ʿ ɿɿɿɿɿɿɿɿɿɿɿɿɿɿɿɿɿɿɿɿɿɿɮȮȮȮȮȮȮȮȮȮȮȮMR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultView:  <   MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    D=vcO<)   x e R > +  {  g T TTTTA ȷȷȤ-ǣǣǐ|iiiiV3 3˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp 3 2 2˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp 2 1 1˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp 1 0 ˙ѷ^3wMEm)W>r.3 aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp 0  0˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp 0  / /˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp / . .˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp . - -˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp - , ,˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp , + +˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp + * *˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp * ) )˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp ) ( (˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp ( ' '˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp ' & &˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp & % %˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp % $ $˙ѷ^3wM9^e2=Y{VC)aHR42/>ΑN[E9l(ST($w_s>ަBFgǗp LVALРΠΠΠ@ @ ʀ `Šàà@@άb9 άy άn62 άe)H ά C άP ά9 άM~ ά Lάb9 άnh = @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @9999 9 9999999999"9 9!9#99$98959694979%999E9B9C9A9D9: 9F 9R 9O 9P 9N 9Q 9G!9S!!!!9T"9]"9p"9n"9m"9o"9^#9s#9x#9w#9y#9t$9z$9$9$9$9{%9%9%9%9%9%9%9%9&9&9&9&9&9&9&9&9'9'9'9'9'9'9(9((9((9)) ) ) ) )* ****++ ++!+,",',(,&,), *, +,#-,-_-^- `- a- b--/8/t/s/ u/ v/ w/90@0B0C0A1F1H1I1G2P2T2U2Q3c3h3g3 i3 j3d3dLVALЇ v e eeeeeeeeeeeeeeeT TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTCCCCCCCCCWWWWWWWWWWWWWWWkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkknnnnnnnnnnnnnnnnnnnnnnnn]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]LRecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientaMR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultView:  <   MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultView:  <   MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultView:  <   MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2RecordLocksODBCTimeoutMaxRecordsRecordsetType FilterOrderByOrderByOnOrientationDefaultViewC  <    MR2 ValidationRuleValidationTextOrientation FilterOrderByOrderByOnDefaultViewColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionSmartTags'   h J#       m   n JNAME       m   lCITY       m   LVALʾSPJ7-FORNITORE PEZZO PRJ CHE SIANO NON NELLA STESSA CITTA'#SPJCrea un report in visualizzazione Struttura!^7K[ L\eAGE_CorpoIntestazioneMascheraPiDiPaginaMascheramS_S#d S__EtichettaS#_EtichettamP_P#d P__EtichettaP#_EtichettamJ_J#d J__EtichettaJ#_Etichettam QTYd  QTY_Etichetta08=Bb cve gI@SPJSPJ Ariald2e12bRcRfbg237bchbcghMS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cdh[o2ej[p5bcr35cd zbcijMS Sans Serif{5bcJ `(IntestazioneMaschera%}(E_"` Corpo@D=xGFYu9_m7UF`5arb e S#S#S_=Ya Nd)d5U`9arbcS#_EtichettaS#S__EtichettaʇϻGICt׏m7UF`5ab e kP#P#P_ɉڹEGq Ud5U`9abcP#_EtichettaP#P__Etichetta C`w~AAVJm7UF`5ab e kJ#J#J_Fcs#ERaqFd5U`9abcJ#_EtichettaJ#J__EtichettaGB_JU_im7UF`5atbekQTYQTYzz|j=OE1JW8d5U`9atbcQTY_EticheTypeInfo;,BlobDelta7PropData6 PropDataRttaQTY+ׅ+Np9&`&PiDiPaginaMaschera!o%Lm[g(& 0CB0DataAccessPages &X&X0m}X3m}X3DirData5Blob @8dir_VBA_PROJECT PROJECT-cPROJECTwmT-1742-45E2-8FE7-99A45DC27A6B}" Name="spj" HelpConID="{A87D8758-1742-45E2-8FE7-99A45DC27A6B}" DocClass=Form_SPJ/&H00000000 Name="spj" HelpContextID="0" VersionCompatible32="393222000" CMG="C1C328A82CA82CA82CA82C" DPB="82806BA82DA92DA92DEtichettaQTY+ׅ+Np9&h1U` ab@c@iFine Chiudi"[EvLVALhD0&rL0& p.?r &r8 rr   rpr<rrr8r/ @S8rrrrr-. @P 8rrrr`rrI/ @SPJ 8rrrrrrr d J.J#J( r rrrr@rr rэJ rx r rr ]B@32-NdC dei progetti nn forniti con pezzi rossi dai fornitori LONr ` rp r[J#]` rrэJ r0 r` r rrr$rrrrrr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rr8 rrrrrv Hr@rrv@ rrrrv@ rr#rrv@ #r#r0&r0 rrqrrrrrrrrrrrrrrrrrrrrrrrrrrrrr8r 8 rHr r rJHrr Hrr rrr drr@ rrLrXr\r rrHr`r8rrrr dHr d@ Hrr Hrr dHrSPJHrr Hrr Hrr rrrXr rhrr "rFrr dr dr8r rxr Dr rlr@rHr0rr rrhrr r4r SPJJ#( HrLr rtrHrPrxr SPJJ#PHrr Hrr rrrrr %rFr8r d#r dr |r(r!r#"rp"r"r"r@"r"r r COLORD"r 'RED' t"r |r"r!r"r!rx"r"rr rH#r "r`#rh#r|#r"PrimaryKey( r#r "r#r#r#r"rPrimaryKeySHrr Hrr #r#r0$rh$r$r$r$r$r 0$rCITY$r'LONDON'%r$r$rx$rr r%r %r%r%r%r"PrimaryKey( r%r  %r&r%r%r%rPrimaryKey$ LVALРΠ@ άv ʾSPJ32-NdC dei progetti nn forniti con pezzi rossi dai fornitori LONά_9ά_9ά_9X 0SPJPJP(Sά_9άv LVALhD*  n  ?  P 0   @                 d  d  d   SPJ.S#SPJ SPJ.P# SPJ.J# SPJ.QTY(       +}6ǭ@0 8  I  I  I  I SPJ`  X   I/ @~sq_fSPJ8                 I  I  I IISPJ  0   8   @   H       H P   8 H X h x P  P  P  P  P  P  P  P  P  P  P  P  P  P  P  P  P  P  P  P  P  P  P  P  P  P  P  P  P  P     H  H  H     z  0  I8  P    0  d  dP  d  8  P    SPJ d`  dp  d  d  SPJS# SPJP# SPJJ#PrimaryKey  v     H Hq H H H H H H H H H H H H H H H H H H H H H H H H H H H H    P 0   0 SPJPrimaryKey 0  @   H 0  0 h  K[ent Procedure]H 0CB0ce] Form_SPJ=27, 35, 1013, 667, Form_SPJForm_SPJͬ L\eAGE_CorpoIntestazioneMascheraPiDiPaginaMascheramS_S#d S__EtichettaS#_EtichettamP_P#d P__EtichettaP#_EtichettamJ_J#d J__EtichettaJ#_Etichettam QTYd  QTY_Etichettadefghijklmnoprz{mdmdmdmd08=Bb cve gI@SPJSPJ Ariald2e12bRcRfbg237bchbcghMS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cdh[o2ej[p5bcr35cd zbcijMS Sans Serif{5bcJ `(IntestazioneMaschera%}(E_"` Corpo@D=xGFYu9_m7UF`5arb e S#S#S_=Ya Nd)d5U`9arbcS#_EtichettaS#S__EtichettaʇϻGICt׏m7UF`5ab e kP#P#P_ɉڹEGq Ud5U`9abcP#_EtichettaP#P__Etichetta C`w~AAVJm7UF`5ab e kJ#J#J_Fcs#ERaqFd5U`9abcJ#_EtichettaJ#J__EtichettaGB_JU_im7UF`5atbekQTYQTYzz|j=OE1JW8d5U`9atbcQTY_EtichettaQTY+ׅ+Np9&`&PiDiPaginaMaschera!o%Lm[g(&lmnoprz{mdmdmdmdhͬ L\eAGE_CorpoIntestazioneMascheraPiDiPaginaMascheramS_S#d S__EtichettaS#_EtichettamP_P#d P__EtichettaP#_EtichettamJ_J#d J__EtichettaJ#_Etichettam QTYd  QTY_Etichettah  FineTrova record\4H4bÕ`&PiDiPaginaMaschera!o%Lm[g(&xCYCr|^,!Z(*)AccessVBAWin16~Win32MacVBA6#spjDAOstdole`VBIDEAForm_SPJ _EvaluateFormCorpojfIntestazio08=Bb cve g hT i j$kI@SPJSPJ Ariald2e12bRcRfbg237bchbcghMS Sans Serifi1ghj1ghk1bcl23:bc g[m4bg[n2cdh[o2ej[p5bcr35cd zbcijMS Sans Serif{5bcJ `(IntestazioneMaschera%}(E_"` Corpo@D=xGFYu9_m7UF`5arb e S#S#S_=Ya Nd)d5U`9arbcS#_EtichettaS#S__EtichettaʇϻGICt׏m7UF`5ab e kP#P#P_ɉڹEGq Ud5U`9abcP#_EtichettaP#P__Etichetta C`w~AAVJm7UF`5ab e kJ#J#J_Fcs#ERaqFd5U`9abcJ#_EtichettaJ#J__EtichettaGB_JU_im7UF`5atbekQTYQTYzz|j=OE1JW8d5U`9atbcK[QTY_ZNKVSLNWHIVIQDZBFWGCBKMDCDRD:0* pHdspj@= d  qB J<  DAO>DAO *\G{00025E01-:0C  0046}#5.0#0#C:\Program Files\Common Microsoft Shared\w350`.DLL# 3.5 Object Libra,ryHTst dole>fstdolje]h^]043[V-]2]WINDOWS\System32\22.tlb#OLE Automation0VBIDE> VBIDEDDE157D5.3 Qmi\Q comuniB\OVBA\6E6EXT.OLBHQVisual Basic for Applic/s Extensibility *@Form_S`PJGA[rm_SP@J@ZNKVSLNWHIVIQDZBFWGCBKMDC@DRD28ANKV@ L@WHJVQ@LZ@NFWGC@KMC6RA@ 1BB,*H8"(B+BA+RA~1\FILECO~1\MICROS~1\am  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\FILECO~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications *\G{4AFFC9neMascheraPiDiPaginaMaschera_S_3_ S__EtichettamP_^ P__EtichettaJ_] J__Etichetta)QTY QTY_Etichetta(Comando8Comando8_Click}dErr_Comando8_ClickHScreenIPreviousControlSetFocusDoCmdƧ DoMenuItem&e acFormBar acEditMenu acMenuVer70XExit_Comando8_Clicks+MsgBoxRErro Description Fineo Fine_Click~qClickT   {8C(5%EN L\eAGE_v@(?mxME A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Programmi\Microsoft Office\OFFICE11\MSACC.OLB#Microsoft Access 11.0 Object Library*\G{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL#Microsoft DAO 3.5 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\System32\stdole2.tlb#OLE AutomationP*\G{0002E157-0000-0000-C000-000000000046}#5.3#0#C:\Programmi\File comuni\MicK[rosoft Shared\VBA\VBA6\VBE6EXT.OLB#Microsoft Visual Basic for Applications Extensibility 5.3 qB8ZNKVSLNWHIVIQDZBFWGCBKMDCDRD0742eb8171Form_SPJ8((SLS S<N0{98E1BD4C-655C-4741-8012-45CCC45F14F6} 8 (%p0xLN`|| % %pp`x0qB " 0xpop :B@BAttribute VB_Name = "Form_SPJ"  Bas|0{98E1BD4C-655C-4741-8012-45CCC45F14F6} |GlobalSpacAFalse dCreatablTru PredeclaId"Expose_Templat@eDeriv%CustomizD$Option Comp@ DT P&* Sub Fine_Click() DoC md.ClK End ( LVALРΠ@ ά(bIʾJCrea una query in visualizzazione Strutturazzo a tutti i prjONCrea una maschera mediante una creazione guidata!^7άjjI άjjI ά(bI LVALʾSPJ15-numero totale di progetti forniti da S1scun fornitoreSPJCrea un report in visualizzazione Struttura!^7YNOO Y d Y d Y dJ# JNAMECITYOQYPrimaryKeyPrimaryKeyvv1LVAL $/ 3/ $/ I/ @/ / x/ / / / /  /  / / / z $/  4/ $/  IX / X/ 0 / / X!/ / h!/ / x!/  d/  d/  d(/ `/  d/  d/  d/  d@/  dx/  d/ /  d /  dX/  d/ /  d/ h@H#/ P#/ X#/ `#/ h#/ p#/ x#/ #/ #/ #/ #/ #/ #/ #/ #/ #/ / / (/ `/ / / / @/ x/ / /  / X/ / / / 8/ / / @ / SPJ d0$/  d@$/  dP$/  d `$/ SPJS# SPJP# SPJJ#PrimaryKeyJ d$/ PrimaryKeyP d$/ PrimaryKeyS d%/ PrimaryKey(%/ / v @,/ 8,/ / v -/ `-/ // / v X// 8// 0/ / v 01/ 1/ 2/ / */ */q */ */ */ */ */ */ */ */ */ */ */ */ */ */ */ */ */ */ */ */ */ */ */ */ */ */ */ */ 83/  / x3/ 2/ `+/ / +/ 1/ / +/ // / %/ ./ SPJH/ %/  H/ %/  H/ %/  / %/ @,/ !/ x,/ -/ ,/ 0-/ ,/ @-/ JPrimaryKeyH/ &/  / &/ -/ P-/ -/ -/ / &/ ./ ./ ./ ./ "PrimaryKey( ,/ ./ ./ // ./ ./ ./ PrimaryKeyPPrimaryKeyH/ '/  / '/ X// // // // / '/ h0/ 0/ 0/ 0/ "PrimaryKey( x,/ 0/ // 0/ 0/ 0/ // PrimaryKeySPrimaryKeyH/ (/  / (/ 01/ 0/ h1/ 1/ / (/ @2/ X2/ `2/ t2/ "PrimaryKey( @,/ 2/ 1/ 2/ 2/ 2/ 1/ PrimaryKey,/ -/ // h1/ / */ / */ / */ / */ x3/ 2/ 3/ X4/ 3/ h4/  4/ x4/ x3/ 4/ 3/ 4/ 3/ 4/  4/ 4/  N @[8R[:R[<R[>R[@R[BR[DR[FRPNOOOOOOOnJ8`7_6^5]4\3[2Z1DLVAL BThDd$6$ ;?` 6#66 6  66<66686 ]B@J866666I/ @SPJ 8666666 d  SPJ.S#SPJX6P6666c:@ 66 6`[SPJ6666I/ @{35-NdC fornitori che forniscono lo stesso pezzo a tutti i prj*6 66[S#]66`[SPJ 666 6066$6666666666666666666666666666666666666666666666666666666666666666666h 66v 666v@ 666v@ "6"6"606060q6060606060606060606060606060606060606060606060606060606066 666 6SPJH6 6 H6 6 6666 6D6 6 dh6 d6@6 d66 6 d666666 66 d6 d@ H606 66 d666 H6h6h666 66x 86h6H6 d6( d6666X6SPJH66 H66 6666 d@ 66 6666h6(6666 66 t$66@6X#6 606-66h6 66@66 6 D6 6l6x66|6 6[P#] 6 h666 66H666666|(6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 66}(6666666666666666666666666666666666A X"6`"6 #6!6#66x #6 #6X"6(#6"6"6X#6#6JPrimaryKeyH66 "666!66!6 #6"6 #6[[J#6#6X#6#6|8 6#6#6#6#6#6#6#6#6#6#6#6#6#6#6#6#6#6#6#6#6#6#6#6#6#6#6#6#6#6#66}8 6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$6t$66 LVALʾSPJ8-NdC prj forniti cn ilP1 in qty media media maggiore maxprj j1SPJCrea un report in visualizzazione Struttura!^7( LVALРΠ@ ά  ʾSPJ35-NdC fornitori che forniscono lo stesso pezzo a tutti i prj*SPJCrea un report in visualizzazione Struttura!^7ά_9X ά_9X ά  NJ4Athens NJ5London NJ6Oslo  NJ7London NJ1SorterParisNJ2PunchRome NߏJ3ReaderAthensNޏJ4ConsoleAthensNݏJ5CollatorLondonNߏJ6TerminalOsloNJ7TapeLondon pLVALhD< ]6 $  ?@ ]6]6x]6 ]6 O  <x]6p]6]6x]6 d  SPJ.P#SPJ]6]6X]6 ]6]6k|@]6]6 p]6x]6 H]6P]6 x]6GKS]6]6]6]6/ @J]6]6]6]6 ]B@SPJ]6]6]6]6I/ @{10-pezzi forniti dai fornitori di Londra ai progetti di Londra ]6x]6P]6 ]6]6SPJ.[P#]]6SJx]6GKSPJ x]6p]6]6 ]6]6]6$]68]6@]6H]6P]6X]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6x]6]6h]6H ]6]6v ]6]6]6v ]6]6]6]6v ]6]6p]6 d0O ]6]6]q6]6]6]6]6]6]6]6]6]6]6]6]6]6]6]6]6]6]6]6]6]6]6]6]6]6]6]6]6@]6 x]6P]6(]6 h]6]6]6`]6]6]6(]6]6JH]6 ]6 H]6 ]6 ]68]6p]6]6]6]6]6 8]6 J.CITY]6'LONDON' ]6]6]6]6]6 ]6]68]6SPJ SPJJ#H]6]6 H]6]6 H]6]6 ]6]6]6h]60]6x]6]6 ]6]6(]60]6D]6 SPJJ#( ]6\]6 ]6]6X]6`]6]6 SPJJ#SPrimaryKeyH]6]6 H]6]6 ]6]6]6@]6]6 ]6]6 ]6]6]6"PrimaryKey( ]6,]6 `]6T]6(]60]6P]6PrimaryKey]6]6]6]6 8]6 J.CITY ]6 ]6 S.CITY]6]6]6`]6]6]6 d]6 d@ H]6]6 P]6]6 dP]6*LVAL:hD~p!7p!$ 0?78!7 77 z  < 777 777 777 777 d  d  d  SPJ.S#SPJ SPJ.P# SPJ.J#777775@ 0787 77 77 77`\7GKP\K 7GK 7GK SPJH77@77I/ @P8 70 70 77-. @JH 7@ 7@ 77 ]B@S 7 7 77/ @m7-FORNITORE PEZZO PRJ CHE SIANO NON NELLA STESSA CITTA'87777 77 77 77SPJ.[S#]7SPJ.[P#]7SPJ.[J#]7 7GK'7GK H7GKMSPJ 7 7 7 7 7( 7777PJS 7p7H!7$787H7X7h7x7 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77 77777v 777v P787077v `7@777v 87770z 7p7pq7p7p7p7p7p7p7p7p7p7p7p7p7p7p7p7p7p7p7p7p7p7p7p7p7p7p7p7p7@ 7 7p 7 7 777777X7777(7JH77 H77 777SPJ SPJJ#H7(7 H7(7 H7(7 P7(777777 (77777 SPJJ#( 77 (77777 SPJJ#SPrimaryKeyH7@7 H7@7 `7 7777 @7p7 777"PrimaryKey( P77 77777PrimaryKeyPPrimaryKeyH7X7 H7X7 877p777 X7H7 `7h7|7"PrimaryKey( 77 77777PrimaryKey7777 77 7P7$7 7 J.CITY T7 7 S.CITY7777 77777 p7 P.CITY 7 7 S.CITY7 7$707`747 7 J.CITY d7 p7 P.CITY77(77X777777877h77 dP7 d7 d7 d@ d@ d@ H7p7 H7p7 H7p7 p 77 7!7 7(!7 dp 7 d 7 d 78LVAL}HhDph!8h!$ I?80!8 88 z  < 888 888 888 888 d  d  d  SPJ.S#SPJ SPJ.P# SPJ.J#88888@0888>88KKJ880MKK88NKxM8GKOK'8GK\K8GK\KSPJ@88888I/ @P0 8( 8( 88-. @J@ 88 88 88 ]B@S 8 8 88/ @_8-FORNITORE PEZZO PRJ CHE SIANOIN CITTA' DIVERSE88888 88 88 88SPJ.[S#]8SPJ.[P#]8SPJ.[J#]88GK'8GKUK8GKUKSPJ 8 8 8 8 8 8888PJS 8h8@!8$888H8X8h8x8 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88 88888v 888v H808(88v X88888v 8880z 8h8hq8h8h8h8h8h8h8h8h8h8h8h8h8h8h8h8h8h8h8h8h8h8h8h8h8h8h8h8h88 8 8h 88 888p888P88888 8JH88 H88 888SPJ SPJJ#H8 8 H8 8 H8 8 H8 888888 88888 SPJJ#( 88  8 8888 SPJJ#SPrimaryKeyH888 H888 X88888 88h8 888"PrimaryKey( H88 88888PrimaryKey8 8$808`848 8 J.CITY d8 8 S.CITY88888h88PPrimaryKeyH8P8 H8P8 888P88 P88 88$8"PrimaryKey( 8<8 p8d888@8`8PrimaryKey88(88 88888 8 P.CITY 8 8 S.CITY,8 88<8H8x8L8 8 J.CITY |8 8 P.CITY888p888P8888 dH8 d8 d8 d@ d@ d@ H8h8 H8h8 H8h8 h 88 8!8 8 !8 dh 8 d 8 d 8 LVALά9 ʾJea una tabella in visualizzazione Struttura8-FORNITORE PEZZO PRJ CHE SIANOIN CITTA' DIVERSECITTA'LondraA ^7