5q      ?@@?@@@@@@ @"@$@&@(@*@,@.@0@1@2@3@@@Sector DriveMacro\  w @ ]Creating temporary Drive Time table 'PointSetToPointSetTime' to store the Drive Time results.IPointSetToPointSetTime MCreate Table [PointSetToPointSetTime] (NodeID Long, Name Text, [Time] Single)   KCould not create table 'PointSetToPointSetTime' in database 'PointSet.mdb'.   S% ID"East"North" S>W Y *Insert Into PointSetToPointSetTime Values(ID"|, |"|Name"|"|, | |)|   0Failed to update table 'PointSetToPointSetTime'.   $ KSelect NodeID, Name, [Time] From PointSetToPointSetTime Order By [Time] ASC   Could not open recordset  | % "No matching records in recordset.  | Name" Time"   r Update | Set Name = |"| |"| , [Time] = | |   Where ID = |ID"|   Failed to update table '|'.|  !Drop Table PointSetToPointSetTime   0Failed to delete table 'PointSetToPointSetTime'. 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.|||yThis Macro calculates the nearest location in Point Set 2 to each of the locations in Point Set 1 in terms of Time taken.||OThe results of this analysis are stored in the attribute fields of Point Set 1.||NExtra fields called 'Name', and 'Time' will be created to store these results.|||TThe Reference Point Set 2 must contain a field called 'Name' for this macro to work.|@&@ @ i  &Could not clear the Current Point Set.    :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 C No Point Set has been selected.   C  [Point Set|]| [Point Set|]| NameX!! KThe second Point Set that you select should contain a column called 'Name'.     J &Could not open database 'PointSet.mdb'   J   %Could not open database 'Product.mdb'   .Deleting Name, Time and Distance columns from |.|I Alter Table | Drop Column [Name]|      Alter Table | Drop Column [Distance]|  Y  Y  Alter Table | Drop Column [Time]|    Alter Table | Drop Column [Name2]|    Alter Table | Drop Column [Distance2]|      Alter Table | Drop Column [Time2]|  \  \  Alter Table | Drop Column [Name3]|    Alter Table | Drop Column [Distance3]|    Alter Table | Drop Column [Time3]|    Alter Table | Drop Column [Name4]|  ` ` Alter Table | Drop Column [Distance4]|    Alter Table | Drop Column [Time4]|    Alter Table | Drop Column [Name5]|  $ $ Alter Table | Drop Column [Distance5]|  h h Alter Table | Drop Column [Time5]|    Adding Name and Time columns to |.|I Alter Table | Add Column [Name] Text|  XFailed to add 'Name' column to |   X Alter Table | Add Column [Time] Single|  Failed to add 'Time' column to |   Select Sector From |  KCould not open recordset |   K% "No matching records in recordset. |   Sector"~@ Cal @VD@k@@U mins|DriveMacro\Drive | hFailed to create Project   h  % C"East"North"Cax(=P@"CD|\||@R   Product |   ProductTimem FSELECT |.ID, ||.East, ||.North, ||.Sector, ProductTime.TileName|, ProductTime.Value, ||.Name |INTO ProductPointSetTime |FROM ||| INNER JOIN ProductTime ON ||.Sector = ProductTime.TileName |ORDER BY ProductTime.Value;|  -Failed to create table 'ProductPointSetTime'.    JSelect ID, Sector, Name, Value From ProductPointSetTime Order By Value ASC  Could not open Recordset |    % "No matching records in Recordset. |    Name"Value"  N@  &r Sector"#)SELECT TileName FROM ProductPointSetTime (WHERE (((ProductPointSetTime.TileName)='|(|'))|  Could not open Recordset |    % "($ $ 6SELECT ID, East, North, Sector, TileName, Value, Name FROM [ProductPointSetTime] |WHERE (((Sector)='|#|')) |ORDER BY Value| y6SELECT ID, East, North, Sector, TileName, Value, Name FROM [ProductPointSetTime] |WHERE (((Sector)='|#|' Or (Sector)='|$|')) |ORDER BY Value|  Could not open Recordset |    % "No matching records in Recordset. |    pq%%? " g# =" g" <Update | Set Name = |"||"| , [Time] = | | Where ID = |ID"|  9Failed to update table '|'.|    9 <Drop Table ProductTime  %Failed to delete table 'ProductTime'.    Drop Table ProductPointSetTime  (-Failed to delete table 'ProductPointSetTime'.    ( n?$    FFFinishedI Drive Times completed|' Root' )The Results are stored in the Point Set '2| ' in the '|'|%' directory of the Point Set Library.|