Standard Jet DBnb` Ugr@?~1y0̝cßFNn7&ќ(h#`/{6߱ aC:3Oy[ |*|OWf_Љ$g'DeFx -bT4.0&dv Y;S << 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 OwnerParentIdRmtInfoLongRmtInfoShortTypeniYYIdParentIdName        OYS;Y Y Y  Y 2ACMFInheritableObjectIdSID  AtYObjectId YS1Y  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttribute -YSY Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationshipYv1b N  : k & W  C t/    @X  @`@@  @@ @  @    @ OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^QkiQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^mJL^QkLdYMdmmJ^dbOiJ0MYmmJmiJfJimQbxJfQxxdJOJiiYqdfQxxd0MdOYMQSdibYmdiYMWQSdibYkMdbdU^YkmQkkYfQxxYMWQSdibYkMQk:0 MdOYMQ+kmJmd+SdibYmdiY+fJiYUYMdOYMYfQxxYMdbfYoOYobSdibYmdiQW0MdOYMY+fQxxYMdOYMY+fQxxY+kfMdffYQOYMdOYMYbdbiYOdbOJbmYMWQiYkYQOdbdbQ^^JkmQkkJMYmmJ0SdibYmdiQQfQxxdbQ^^JkmQkkJMYmmJQkmJmokOYqOJ:6%SdibYmdiYMWQSdibYkMdbdf:0 SdibYmdiYMWQSdibYkMdbdf:q:0 SdibYmdiYMWQSdibYkMdbdfQxxY0SdibYmdiYMWQSdibYkMdbdmommYYfQxxY0SdibYmdiYMWQSdibYkMdbdmommYYfQxxYq:0SdibYmdiYMWQbdbSdibYkMdbdf:0 SdibYmdiY+OY+fJiYUY+Mdb+kmJmok+`JUU+:6!SdibYmdiY+fJiYUY+diOYbJmY+ko^^d+kmJmok"Uidof0YbkQiY`QbmdYbkQiY`Qbmd+fYbkQiY`Qbmd+k`QOYJ0`kvkJMMQkkdL[QMmk`kvkJMMQkku`^`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkbd`QSdibYmdiQMWQYbYxYJfQiM0bd`YSdibYmdiYMWQSdibYkMdbdJ^`QbdobfQxxdidkkd0 bo`QidSdibYmdiYMWQSdibYkMdbdJ^`QbdobfQxxd0bo`QidSdibYmdiYMWQSdibYkMdbdJ^`QbdobfQxxdq:0ffQkdMd`f^QkkYqdOQU^YdUUQmmYSdibYmYOJk80fQkd+Yb+UiJ``Y+kmJbOJiOhmvfidOdmmYSdibYmYOJk:0hoQiv80kk+f+kmQkkJ+MYmmJ$kfmJLkfmJL+fmJL+kmommd mommd+k+f#ofOJmQ0JMMQkk^Jvdom`kvkOLko``JivYbSd okQiOQSYbQO   @ @ @ @ @ @ @           !"#$%000000 0!0"0 #0 $0 %0 &0 '0(0)0*0+0,0-0.0$& @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ !"#$%&'()*+,-./0123789 @ A B F G H I J K L M N O * ********* * * * * ******************* *!*"*&*'*(*)***+*,*-*.*/*0*1*2*3*4 *5 *6 *7!*8!*9!*:"*;"*<"*=#*>#*?#*@$*A$*B$*C%*D%*E%*F&*G&*H&*I'*J'*K'*L(*M(=(=)=)=)=*=*=*=+=+= += ,= ,= ,= -=-=-=.=.=.=  456:;<$=$>$?&C&D&E   L @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @                            "! #&%$'zxy{(-2/01.36547;9:<8=ECDF G>HLMJKINRSPQTOUYZWX[V\uvwst4]441424/40434444<4;4=454>4E4F4D4G4?4H4K4J 4L 4M4I4N4R4P4Q 4S4O 4T 4W 4V 4X 4U!4Y!4\!4[!4]!4Z"4^"4a"4`"4b"4_#4c#4i#4f#4g#4e#4h#4d$4j$4m$4l$4n$4k%4o%4r%4q%4s%4p&4t&4y&4w&4v&4x&4u'4z'4}'4|'4~'4{(4(4(4(4(4)4)4)4)4)4*4*4*4*4*4+4+4+4+4,4,2,2,2,2,4-2-2-2 -2 -2 -2 -2 -2.2.2.2.2.2.24{(4(4(4   &d _ Z 7 T  _   jKiWQk%9tg$o@$o@FORNITORE E PEZZO NELLA STESSA CITTA E STATUS DIV DA 20 ]@-`@, @blyo@4myo@S_P_STESSA_CITTA ]@-`@,ZNNBBBBBBB@ @lo@lo@TUTTO_S_P ]@>z@;`@,XLL@4444442 `,GRVo@w\o@fORNITORI_PARIGI_ORDINATI_SULLO_STATUS ]@ -`@,zznnnnnnnl @Un@oYUn@FORNITORI_DI_PARIGI_CON_STATUS_MAGG_20 ]@V`@ #zznnnnnnnl @Kn@LKn@TUTTO ]N@N`@ #D88,,,,,,,* @WGn@Op@PESO_IN_GRAMMI_STANDARD ]@`@#h\\PPPPPPPN @3n@]#T@CODICE_STATO_FORNITORI_PARIGI ]@<`@+thh\\\\\\\Z @br+n@br+n@CODICI_PEZZI_SP ]~@ `@#XLL@@@@@@@> @(n@p(n@CODICI_PEZZI ]|@`@+RFF:::::::8 @ ʫm@] @AccessLayout ]4MR2KeepLocal T"@Azz:::::::8 @ cm@cm@@INSERIMENTO_P ]"@%`@#THH<<<<<<<: @ ,m@aVm@@INSERIMENTO_S ]"@`@#THH<<<<<<<: @ %m@om@@INSERIMENTO ]"@`@#PDD88888886 @ m@m@`TAB SP ]L@ `@#F::......., @&l׽m@br+n@SP ]@222&&&&&&&$ @ UPm@UPm@`TAB_P ]L@`@#D88,,,,,,,* @$Im@p(n@P ]@000$$$$$$$" @Em@bEm@MSysAccessXML ]4MR2KeepLocal  T|||<<<<<<<: @@Dm@LEm@`TAB_S ]L@`@#D88,,,,,,,* @-m@V6n@S ]l@000$$$$$$$" @ zm@ zm@DataAccessPages ]@@@@@@@@@@>  zm@ zm@SysRel ]..........,  zm@ zm@Modules ]0000000000.  zm@ zm@Scripts ]0000000000.  zm@ zm@Reports ]0000000000.  zm@ zm@Forms ],,,,,,,,,,*  zm@ zm@UserDefined ]A@DDD88888886 @ zm@ zm@SummaryInfo ]@DDD88888886 @ zm@?7 zm@MSysAccessObjects ]DDDDDDDDDDB Rzm@Rzm@MSysRelationships _DDDDDDDDDDB Rzm@Rzm@MSysQueries _88888888886 Rzm@Rzm@MSysACEs _22222222220 Rzm@Rzm@MSysObjects _88888888886 Rzm@Rzm@MSysDb ]@:::......., @Rzm@Rzm@Relationships _<<<<<<<<<<: Rzm@Rzm@Databases _44444444442 ]zm@]zm@Tables _.........., fP{hUB/A S @ ,  |  B /   l Y 2 o\I"r_K8%taN:'  ]   ]  MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp   ]   ]  MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp   ]   ]  MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp   ] & ] &MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp & ]   ]  MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp   ] $ ] $MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp $ ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  X  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  X  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  X  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  X  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  X  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  X  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ]  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp TMfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp TMfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ]  ]  ]  X  ]  X  ]  ]  ]  ] LVAL2ΥYY  ˧ ʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧʧY YYYYYYYɡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡǡ     7 COLOR     9 WEIGHT     5CITY MR2RequiredOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenR PN       ^pZ@"$YCK    U  ln3T~Mmx7 PNAME     MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultView:  MR2ReMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultView:  MR2ZRecordLocksODBCTimeoutMaxRecords Filter MR2ZRecordLocksODBCTimeoutMaxRecords Filter  <MR2^ANSI Query ModeAccessVersion BuildProjVerB   08.50 c #MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    QomB9zZO UCQZ\=GmnV6n@HyS{g$~cDzћˇCQZ\=GmnSNAME}kgF& azmCQZ\=GmnSTATUSMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    2.C=lU/,8 0 UCQZ\=GmnV6n@SMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL^  <    CT J  UMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL^  <    9+UOߦ 0 anC1 0x000K[ࡱ> Root Entry]-@ PropData Forms ^ D^ DReports^ D^ DModules^ D^ DScripts^ D^ DVBA^ D]-Cmdbars^ D^ DCustomGroups  D DDirDataVBAProjectD`2\-AcessVBAData Modules^ D^ DScripts^ D^ DVBA^ D@8DCmdbars^ D^ DDataAccessPages ^ D^ DDatabases ^ DG0 ^ DGBlob   !"#$%&'()*+,K[CustomGroups  D DDirDataVBAProjectD@6DAcessVBAData   VBAD@6DPROJECTwmPROJECT#_VBA_PROJECT  !"#$%&'()*+,-Root EntryG PropData Forms ^ D^ DReports^ D^ DijMSysDbID="{8F246133-E9C2-4B09-ABCC-20E400C602AF}" Name="es1_sp" HelpContextID="0" VersionCompatible32="393222000" CMG="9D9F48E978827C827C827C827C" DPB="3A38EF908D918D918D" GC="D7D5023702499E4A9E4A61" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 w0* pHdes1_sp$@T=j B J < stdole>stdole( f%\*\G{00020430-C 0046}#2.0#0#C:\WINNT\System32\c2.tlb#OLE Automa0tion^gADODB> ADOBCCDB1C10-8CAA006D2EA 4C1CProgrammi\File comun iK\7\msado21LMicrosoft ActiveX Data Objects 2.1 LibraryFEo am "*\G{000204EF-0dir {K[000-0000-C000-000000000046}#4.0#9#e:\PROGRA~1\officexp\FILES\PFILES\COMMON\MSSHARED\VBA\VBA6\VBE6.DLL#Visual Basic For Applications *\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Programmi\Microsoft Office\Office10\MSACC.OLB#Microsoft Access 10.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINNT\System32\stdole2.tlb#OLE Automation*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#C:\Programmi\File comuni\System\ADO\msado21.tlb#Microsoft ActiveX Data Objects 2.1 LibraryBox %AccessVBAWin16~Win32MacVBA6# Progetto1DLstdole`es1_sp;ADODBs<  ijMSysDbID="{8F246133-E9C2-4B09-ABCC-20E400C602AF}" Name="es1_sp" HelpContextID="0" VersionCompatible32="393222000" CMG="CAC81F57ED5BED5BED5BED5B" DPB="949641A1C16AC26AC26A" GC="5E5C8BFB9F0F6810681097" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 VBAD`2\-PROJECTwmPROJECT#_VBA_PROJECTw0* pHdes1_sp$@T=j B J < stdole>stdole( f%\*\G{00020430-C 0046}#2.0#0#C:\WINNT\System32\c2.tlb#OLE Automa0tion^gADODB> ADOBCCDB1C10-8CAA006D2EA 4C1CProgrammi\File comun iK\7\msado21LMicrosoft ActiveX Data Objects 2.1 LibraryFEo am *\G{000204EF-0dir {)YN Y  Y  (Y 2 Y 4SN SNAME STATUSCITYdv!&oR5jMS4 P5 S4 P4 ,S4 P2 S3 P2 S2 P2 S2 P1 ,S1 P9 S1 P8 S1 P7 ,S1 P6 dS1 P5 dS1 P4 S1 P3 S1 P2 S1 P1 ,JLVAL+E ˭ ///////ŮîîîîîîîîîîîîîîîîîîîîColumnWidthColumnHiddenRecordLocksODBCTimMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDR  <    UKOEbMR2ColumnWidthColumMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultView:  MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultView:  <   MR2ColumnWidthColumnHiddenRecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL1Expr1001 b   <     t+yZ@FB 5o2 Uln3T~Mmxp(n@VP^pZ@"$YCln3T~MmxPNC>Ӎ@np}ln3T~MmxWEIGHTMR2RequiredOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenR SN       6Dg\ۓKIRK    U  CQZ\=GmnO SNAME      {g$~cDzћˇQ STATUS      }kgF& azmMCITY      CԙmfMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    MD`J"فoFh ` UzpLq._Ybr+n@SP/5ӜcGIޚzpLq._YPNMR2RequiredOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenR SN       ekJ&R PN       /5ӜcGIޚK    U  zpLq._YK QTY      DTMbM3MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    ʑO7Yf ^ Uln3T~Mmxp(n@XP^pZ@"$YCln3T~MmxPNMR2RequiredOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenR PN       ^pZ@"$YCK    U  ln3T~MmxO PNAME      SMDVA)^O COLOR      ɒFi;Z\Q WEIGHT      C>Ӎ@np}MCITY      U7G3<ʍW||^4r> m O / H * { ?  a A #  y yyyy[ =  |^@ cCƓaA j;aA!}N.ŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠX&`@S.CITY='PARIS'- 'S  S.STATUS' gS.SN# gP SP S P.CITY% gS.CITY% g  GS.CITY=P.CITY AND STATUS<>20; 'P S P.*" gS.*" g  Gn BS.CITY=P.CITY, 'n BP n BS  BP.*" g BS.*" gn B  B GP S P.*" gS.*" g  G dSTATUS' /CITY='PARIS'+ 'S STATUS% gSN! g  GCITY='PARIS' AND STATUS>209 'S STATUS% gSNAME$ g  G  G S     GP  WEIGHT*454) g'PESO IN GRAMMI:'0 gPN! g  G  GSP PN! g  GP PN! g  G uiCITY'ROME'- w uiWEIGHT17- w uiCOLOR'BLUE'/ w uiPNAME 'SCREW'0 w uiPN'P3'' w uiP O Bui  ui G CITY 'ATHENS'/ w STATUS30- w SNAME 'ADAMS'0 w SN'S5'' w S O    G τCITY 'ATHENS'/ w τSTATUS30- w τSNAME 'ADAMS'0 w τSN'S5'' w τS O τ  τ G  @ g    G uiN@ g Bui  ui GR@ g  G~LVAL` T TTT̺ L 22ÎJJöSN IN ( SELECT SN FROM S WHERE S.CITY='LONDON' )SELECT PN FROM P WHERE WEIGHT>16SELECT PN FROM SP WHERE SN='S2' SN IN ( SELECT SN FROM SP )EXISTS ( SELECT * FROM SP WHERE S.SN=SN )SN IN ( SELECT SN FROM SP GROUP BY SN HAVING COUNT(PN)= ( SELECT COUNT(*) FROM P ) )NOT exists ( select * from p where not exists ( select * from sp where sn=s.sn and pn=p.pn ) )NOT EXISTS ( SELECT * FROM SP A WHERE SN='S2' AND NOT EXISTS ( SELECT * FROM SP B WHERE B.SN=S.SN AND B.PN=A.PN AND B.SN<>'S2' ) )NOT EXISTS (SELECT * FROM SP WHERE SN=S.SN AND PN='P2')EXISTS (SELECT * FROM SP WHERE SN=S.SN AND PN='P2')S.SN IN (SELECT DISTINCT SN FROM P,SP WHERE COLOUR='RED' AND P.PN=SP.PN)CREATE TABLE SP ( SN CHAR(5) NOT NULL, PN CHAR(6) NOT NULL, QTY INTEGER )CREATE TABLE P ( PN CHAR(6) NOT NULL, PNAME CHAR(20), COLOR CHAR(6), WEIGHT SMALLINT, CITY CHAR(15) )CREATE TABLE S ( SN CHAR(5) NOT NULL, SNAME CHAR(20), STATUS SMALLINT, CITY CHAR(15) ) S Y NY @ Y Y x Y @ Y k Y kvId LValueObjectGuidObjectNameProperty Valuevkvk kvvkvk!kvvkvk"kvYYYId$ObjectGuidProperty$ObjectNamePropertyHv1b   LVAL @ ``@ά(bI ά(Y ά(Y ά(Y ά(Y ά(Y ά(Y ά(Y ά(Y ά(Y ά(Y Y N%% Y  Y  ( Y 4 Y @ Y BPN PNAME COLOR WEIGHTCITYdvXYlsN'' Y  Y  Y SNPNQTYdv?VWS5 ADAMS ATHENS S4 CLARK LONDON S3 BLAKE PARIS S2 JONES PARIS S1 SMITH LONDON  $:t P6 LOG RED LONDON P5 CAM BLUE PARIS P4 SCREW RED LONDON P3 SCREW BLUE ROME P2 BOLT YELLOWPARIS P1 NUT RED LONDON NvcO<)   x e R > +  {  g T A ȷȷȤ-}jVC0 lYE2 n[H( ] ' ] 'MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp ' ] & ] &MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp & ] % ] %MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp % ] $ ] $MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp $ ] # ] #MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp # ] " ] "MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp " ] ! ] !MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp ! ]   ]  MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp   ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]  ] MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp  ]   ]  MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp LVAL Р@ `@ά(Y ά(bI ά(bI ά(bI ά(bI ά(bI ά( ά(bI ά(bI ά(bI ά(bI ά(Y LVALР@ ʀʀʀ ``@ά(bI ά(bI ά(bI ά(>o ά(Y ά(Y ά(Y ά(Y ά(Y ά(Y ά(Y LVALzNNNNp p\ \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ʘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘǘJJpMR2RecordLocksODBCTimeoutMaMR2RecordLocksOMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    oD#4@ U CQZ\=GmnV6n@S{g$~cDzћˇCQZ\=GmnSNAME MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    Q*9Nh)Zڬ UCQZ\=GmnV6n@SzpLq._Ybr+n@SP{g$~cDzћˇCQZ\=GmnSNAME MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    V0Ϻ6fIӥ?8 0 UCQZ\=GmnV6n@SMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    |R/N-k4g  UCQZ\=GmnV6n@S6Dg\ۓKIRCQZ\=GmnSNzpLq._Ybr+n@SPekJ&zpLq._YSNln3T~Mmxp(n@P^pZ@"$YCln3T~MmxPN/5ӜcGIޚzpLq._YPNCԙmfCQZ\=GmnCITYU7G3<ʍWln3T~MmxCITYMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLP  <    id;yJceX UCQZ\=GmnV6n@SCԙmfCQZ\=GmnCITYln3T~Mmxp(n@PU7G3<ʍWln3T~MmxCITY}kgF& azmCQZ\=GmnSTATUSMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    OL@S{!W UCQZ\=GmnV6n@SCԙmfCQZ\=GmnCITYln3T~Mmxp(n@PU7G3<ʍWln3T~MmxCITYMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    UKOEb UCQZ\=GmnV6n@xvS6Dg\ۓKIRCQZ\=GmnSN}kgF& azmCQZ\=GmnSTATUS LVALР@ @ ά(bI ʾSPCITTA TRA PARTENZA PEZZO AD ARRIVO PEZZOra 5(^3ά{_C ά{_C ά WI ά(bI K[000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\FILECO~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications *\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Programmi\Microsoft Office\OFFICE11\MSACC.OLB#Microsoft Access 11.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINNT\System32\stdole2.tlb#OLE Automation*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#C:\Programmi\File comuni\System\ADO\msado21.tlb#Microsoft ActiveX Data Objects 2.1 Library Box $AccessVBAWin16~Win32MacVBA6#es1_sp;stdole`ADODBs<   7MMv < : D g X?Iq.f @f @BOICOT.f @5Kۍ @0BOICOTTA LONDRA ]@@`@.XLL@@@@@@@> @- < @}< @0UPDATE ]@3`@?F::......., @,C" @RF @Query1 ]L@<`@.F::......., @+MT@MT@FORNITORI CHE FORNISCONO PEZZI ]@<`@ #vjj^^^^^^^\ @*zIT@zIT@NUMERO FORNITORI CHE FORNISCONO ALMENO UN PEZZO V2 ]@<`@ + @)BT@ DT@NUMERO FORNITORI CHE FORNISCONO ALMENO UN PEZZO ]@ <`@ +~ @(e.p@s>O>p@COPPIE DI CODICI NON RIDONDANTI CHE RISIEDONO NELLA STESSA CITTA ]N@v-`@, @ɛo@ o@CITTA TRA PARTENZA PEZZO AD ARRIVO PEZZO ]35l@<-`@ ,~rrrrrrp `LVAL*MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    zV HCVK U CQZ\=GmnV6n@S{g$~cDzћˇCQZ\=GmnSNAME  fH* P ͕͕͕w U # .ERE@ '.REQTY0% w.ERESP .RE G. . G-P.COLOR='RED' AND P.PN='P2': '-CITYNULL+ w-WEIGHT WEIGHT+53 w-COLOR 'YELLOW'1 w-P - G- - G, G,X7YZ_____2D@1% 7,  G,X7YZ_____1F@1% 7 LVAL MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLP  <    2cAZ gU Uln3T~Mmxp(n@PɒFi;Z\ln3T~MmxCOLORC>Ӎ@np}ln3T~MmxWEIGHTU7G3<ʍWln3T~MmxCITY pϻϻϻϻϻϻϻϻϻϻϻϻϻϻϻϻϻϻϻϻϻϻϻϻϻϝOuWWWWWW# ͒͒͒W 5  i G  x D " b /  g I + tC#e4}]3aC%n=c9aC, ui G,BuiX7YZ_____1F@1% 7,Bui ,ui G+n BSP + B COUNT(SN)( g+n B + B G*'^@ '*'S *' COUNT(*)' g*' *' G)@  ')S ) COUNT(*)' g) ) G(lʎl@  '(lʎlS (ʎlSNAME$ g(lʎl (ʎl G'@  ''s 'sname$ g' ' G&{> G&>{>B@  '&>{>S &{>SN! g&>{> &{> G%v@ '%S %SNAME$ g% % G$n@ '$S $SNAME$ g$ $ G# G#S.SN=SP.SN AND PN='P2'5 '#SP #S #SNAME$ g# # G"Bui@ '"BuiS "uiSNAME$ g"Bui "ui G!BuiPNAME LIKE 'C*'. '!BuiP !uiPNAME$ g!Bui !ui G Bui PN='P2'& ' BuiSP  ui AVG(QTY)' g Bui  ui G PN! gSP  SUM(QTY)' gPN! g  G  COUNT(SN)>1* ' PN! gSP PN! g  GSP.PN=P.PN AND SN='S1'5 'P SP SUM(WEIGHT*QTY). g  G SN='S2'& 'SP  SUM(QTY)' g  GX.CITY=Y.CITY And X.SNӍ@np}ln3T~MmxWEIGHTDTMbM3zpLq._YQTYMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    ѻZXLKb9d \ UCQZ\=GmnV6n@5Sln3T~Mmxp(n@5PMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    YION7-j b UzpLq._Ybr+n@PtSPDTMbM3zpLq._YQTYLVAL$ " "L Lvv22ŊÊÊÊÊÊÊÊÊÊÊ>>>>>>>MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    +Ǣ9F  U zpLq._Ybr+n@SPDTMbM3zpLq._YQTY MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    4 D/&Lr, 6 . U MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    V}_4EʞTuއ UzpLq._Ybr+n@SPekJ&zpLq._YSN MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    "ɪK"}iJ U CQZ\=GmnV6n@S MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    쏙9CJ}. U CQZ\=GmnV6n@S MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    k>~ߍGe U CQZ\=GmnV6n@S{g$~cDzћˇCQZ\=GmnSNAME MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    BKFWG1AU U CQZ\=GmnV6n@s{g$~cDzћˇCQZ\=Gmnsname MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL   <    qC7bO |ź U CQZ\=GmnV6n@S6Dg\ۓKIRCQZ\=GmnSN MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLJ  <    3xN3 UCQZ\=GmnV6n@SCԙmfCQZ\=GmnCITY6Dg\ۓKIRCQZ\=GmnSN}kgF& azmCQZ\=GmnSTATUS  vcO<)   x e R . ] .MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp . ] - ] -MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp - ] , ] ,MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp , ] + ] +MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp + ] * ] *MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp * ] ) ] )MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp ) ] ( ] (MfׄH;8"_U!ȯ_JX+9໷u#ʺSL]o 3iY&ע:}ct2ae .Kp :LVALJhDrxZx Q2?ZZ Z(Z n <$ZZZZZ ZZ,Z@Z$ZZZZZZZ(Z@Z$ZZZZZZZZZ$ZZZZZ ZZ,ZPZ   (       (      S.SNS S.SNAMES.STATUS S.CITYCITYP.PNP P.PNAME P.COLORP.WEIGHT P.CITYCITYZ  Z 0ZZ`Zlo@ZZ ZZ ZNsKZNsPNZNsCOZNsWE ZNsCI ZNs ZNs ,ZNsS( ZZ ZpZ`ZV6n@P Z Zx ZZ`Zp(n@CITYTUTTO_S_PZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ (ZZ @ZZZZZZZZZ(Z@ZZNsZNsPPsZNs  ZNs CITYS Z Z Z Z Z Z Z ZZZZZZNs  ZNs ZNs,ZNsUsh ZNs CITYP Z Z Z Z Z Z ,Z Z DZ ZZZZ(Z@Z ZXZ0Z `Z8Z`ZZZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZ ZZhZZ HZpZ HZpZ ZpZ HZpZ HZZ HZZ HZZ ZZ HZZ Zz ZZZPsZxZZZZZ ZZZz ZZZQsZXZZZZZZZZ8ZZ  xZ (ZZ  Z  XZ (Z  ZZ 8ZL$@ZHZPZXZ`ZhZpZxZZxZZZ ZXZZZZ8Z pZZSPZZv ZZZv PZHZZXZXqZXZXZXZXZXZXZXZXZXZXZXZXZXZXZXZXZXZXZXZXZXZXZXZXZXZXZXZXZZ ZZZ ZZ(Z@ZPZ(ZZ ZSZ@ZPZ8ZPZZZXZZXZZZZPZZ`ZZpZLVALРά{_ ʾSPCrea una query in visualizzazione StrutturaZZO &(^7ά{_ LVAL,MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    +Ǣ9F  U zpLq._Ybr+n@SPDTMbM3zpLq._YQTY MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    +Ǣ9F  U zpLq._Ybr+n@SPDTMbM3zpLq._YQTY LVALʾCrea una tabella in visualizzazione StrutturaBOICOTTA LONDRAn visualizzazione Struttura k^7