1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| INSERT INTO codificationProximite ( LocationPivot, LocationCible, CoefficentSimilitude )
SELECT ProxLocationPivotVBA.LOCATION, ProxGeoEmplacement.LOCATION,
IIf([P] Like Mid([ProxLocationPivotVBA]![ITM_NUM],8,1),3,0)
+IIf([S] Like Mid([ProxLocationPivotVBA]![ITM_NUM],8,1),2,0)
+IIf([T] Like Mid([ProxLocationPivotVBA]![ITM_NUM],8,1),1,0)
+IIf([S] Like Mid([ProxLocationPivotVBA]![ITM_NUM],9,1),3,0)
+IIf([P] Like Mid([ProxLocationPivotVBA]![ITM_NUM],9,1),2,0)
+IIf([T] Like Mid([ProxLocationPivotVBA]![ITM_NUM],9,1),2,0)
+IIf([T] Like Mid([ProxLocationPivotVBA]![ITM_NUM],10,1),3,0)
+IIf([S] Like Mid([ProxLocationPivotVBA]![ITM_NUM],10,1),2,0)
+IIf([P] Like Mid([ProxLocationPivotVBA]![ITM_NUM],10,1),1,0) AS coefCodif
FROM ProxLocationPivotVBA, (ProxGeoEmplacement INNER JOIN CATALYST_LOCATION ON ProxGeoEmplacement.LOCATION = CATALYST_LOCATION.LOCATION)
INNER JOIN CATALYST_LOCCLASS ON ProxGeoEmplacement.LOC_CLASS = CATALYST_LOCCLASS.LOC_CLASS
WHERE (((ProxGeoEmplacement.LOCATION) Like Mid([ProxLocationPivotVBA]![location],1,4) & "*")
AND ((ProxGeoEmplacement.L) Between ([ProxLocationPivotVBA]![L]-([Formulaires]![ProximiteReference]![DistanceProximite]*([CATALYST_LOCATION]![WIDTH]/142)))
And ([ProxLocationPivotVBA]![L]+([Formulaires]![ProximiteReference]![DistanceProximite]*([CATALYST_LOCATION]![WIDTH]/142))))
AND ((ProxGeoEmplacement.H) Between ([ProxLocationPivotVBA]![H]-([Formulaires]![ProximiteReference]![DistanceProximite]*([CATALYST_LOCATION]![HEIGHT]/132)))
And ([ProxLocationPivotVBA]![H]+([Formulaires]![ProximiteReference]![DistanceProximite]*([CATALYST_LOCATION]![HEIGHT]/132))))
AND ((IIf(Mid([Formulaires]![ProximiteReference]![LocationPivot],4,2) Mod 2=1,[ProxGeoEmplacement]![MeubleImpaiir],[ProxGeoEmplacement]![MeublePair])) Not Like "")); |
Partager