5qÎú:ÿÿ      ð?@@ð?@@@@@@ @"@$@&@(@*@,@.@0@1@2@3@@@Sector DriveMacro\ A w@ aCreating temporary Drive Time table 'PointSetToPointSetDistance' to store the Drive Time results.IùÿÿÿPointSetToPointSetDistance¬ ÍSCreate Table [PointSetToPointSetDistance] (NodeID Long, Name Text, Distance Single) ùÿÿÿ ± ÊOCould not create table 'PointSetToPointSetDistance' in database 'PointSet.mdb'.ÿÿ Ê ÍúÿÿÿûÿÿÿSþÿÿÿ% þÿÿÿID"þÿÿÿEast"þÿÿÿNorth"Súÿÿÿûÿÿÿ>WT .Insert Into PointSetToPointSetDistance Values(þÿÿÿID"|, |"|þÿÿÿName"|"|, | |)| ùÿÿÿ ± 4Failed to update table 'PointSetToPointSetDistance'.  â þÿÿÿ$ ÛSSelect NodeID, Name, Distance From PointSetToPointSetDistance Order By Distance ASC ùÿÿÿ ¯ ©Could not open recordset  |ÿÿ ©% â"No matching records in recordset.  |ÿÿ âName" Distance"   r °Update üÿÿÿ| Set Name = |"| |"| , Distance = | |   Where ID = |ýÿÿÿID"| ùÿÿÿ ± ÂFailed to update table 'üÿÿÿ|'.| ÿÿ Â%Drop Table PointSetToPointSetDistance ùÿÿÿ ± 84Failed to delete table 'PointSetToPointSetDistance'.ÿÿ 8ùÿÿÿn*@/This macro will prompt for 2 Point Sets to use.|GThe 1st Point Set is the Point Set to be updated with the nearest node.||8The 2nd Point Set is the Reference Point Set to be used.|||wThis Macro calculates the nearest location in Point Set 2 to each of the locations in Point Set 1 in terms of Distance.||OThe results of this analysis are stored in the attribute fields of Point Set 1.||RExtra fields called 'Name', and 'Distance' will be created to store these results.|||TThe Reference Point Set 2 must contain a field called 'Name' for this macro to work.|@&@ @ iÿ N &Could not clear the Current Point Set.  ÿÿ N :Pick your first Point Set (the one that is to be updated).IB8 Þ No Point Set has been selected.  ÿÿ Þ õ  :'5Pick your second Point Set. The Reference Point Set.IB8 y No Point Set has been selected.  ÿÿ y  [Point Set|]| [Point Set|]| NameX!! 0 KThe second Point Set that you select should contain a column called 'Name'.  ÿÿ 0   € &Could not open database 'PointSet.mdb'  ÿÿ €   Ï %Could not open database 'Product.mdb'  ÿÿ Ï (Deleting Name and Distance columns from |.|I Alter Table | Drop Column [Name]| ± F  F  Alter Table | Drop Column [Distance]| ± ‰  ‰  Alter Table | Drop Column [Name2]| ± É  É  Alter Table | Drop Column [Distance2]| ±   Alter Table | Drop Column [Name3]| ± M  M  Alter Table | Drop Column [Distance3]| ± ‘  ‘  Alter Table | Drop Column [Name4]| ± Ñ  Ñ  Alter Table | Drop Column [Distance4]| ±   Alter Table | Drop Column [Name5]| ± U U Alter Table | Drop Column [Distance5]| ± ™ ™$Adding Name and Distance columns to |.|I Alter Table | Add Column [Name] Text| ± MFailed to add 'Name' column to |  ÿÿ M Alter Table | Add Column [Distance] Single| ± ×#Failed to add 'Distance' column to |  ÿÿ ×Select Sector From | ¯ HCould not open recordset |  ÿÿ H% “"No matching records in recordset. |  ÿÿ “Sector"~@ ÇCal Ç°@ûVE@k@Ÿ@U mins|DriveMacro\Drive |Í eFailed to create Project  ÿÿ eÿ  % fÿ"East"North"Cax(=P@"CD|\||@R  õ Product |   ProductTimem FSELECT |.ID, ||.East, ||.North, ||.Sector, ProductTime.TileName|, ProductTime.Value, ||.Name |INTO ProductPointSetDistance |FROM ||| INNER JOIN ProductTime ON ||.Sector = ProductTime.TileName |ORDER BY ProductTime.Value;| ± ã1Failed to create table 'ProductPointSetDistance'.   Š ãNSelect ID, Sector, Name, Value From ProductPointSetDistance Order By Value ASC ¯ ŽCould not open Recordset |   Š Ž% Ý"No matching records in Recordset. |   Š ÝName"Value"  N@  &r Sector"#°-SELECT TileName FROM ProductPointSetDistance ,WHERE (((ProductPointSetDistance.TileName)='|(|'))| ¯ ùCould not open Recordset |   Š ù% ÿ"($ °$ Ï6SELECT ID, East, North, Sector, TileName, Value, Name FROM [ProductPointSetDistance] |WHERE (((Sector)='|#|')) |ORDER BY Value| ’6SELECT ID, East, North, Sector, TileName, Value, Name FROM [ProductPointSetDistance] |WHERE (((Sector)='|#|' Or (Sector)='|$|')) |ORDER BY Value| ¯ éCould not open Recordset |   Š é% 8"No matching records in Recordset. |   Š 8pq%%ð? "ÿ €# =ÿ" €°"ÿ WUpdate | Set Name = |"||"| , Distance = | | Where ID = |ID"| ± TFailed to update table '|'.|   Š T WDrop Table ProductTime ± Å%Failed to delete table 'ProductTime'.   Š Å"Drop Table ProductPointSetDistance ± K1Failed to delete table 'ProductPointSetDistance'.   Š K nð?$ ƒ   FFFinishedI Drive Times completed|' ÇRoot' Ç)The Results are stored in the Point Set '2| ' in the '|'|%' directory of the Point Set Library.|