Access 2000: Finding a central location

[tennisash]

I have a Table that has over 107,000 records in it. It includes origin
city and state and destination city and state. I am trying to figure
out where the best place to put a new warehouse or warehouses would be
using all of this shipping data. Is there any way that I can do that
using Access 2000? If I could put all of the locations on a map of
some kind that might be useful as well.

Thanks for any help you can give me and Happy Holidays!

 

[KARL DEWEY]

You might try the queries below to see what it looks like. Exchange Mdol and
Kton for number of packages and total weight. These queries will give you
the amount of packages and weight moved through the locations.
Domestic_06
Origin Destination Mdol Kton
CA NY 5 7
CA NY 4 3
NY CA 8 6
AT SF 3 4
SF AT 3 3
NY SF 5 1
SF NY 11 5

tennisash_1
SELECT Domestic_06.Origin, Sum(Domestic_06.Mdol) AS SumOfMdol
FROM Domestic_06
GROUP BY Domestic_06.Origin;

tennisash_2
SELECT Domestic_06.Origin, Sum(Domestic_06.Kton) AS SumOfKton
FROM Domestic_06
GROUP BY Domestic_06.Origin;

tennisash_3
SELECT Domestic_06.Destination, Sum(Domestic_06.Mdol) AS SumOfMdol
FROM Domestic_06
GROUP BY Domestic_06.Destination;

tennisash_4
SELECT Domestic_06.Destination, Sum(Domestic_06.Kton) AS SumOfKton
FROM Domestic_06
GROUP BY Domestic_06.Destination;

tennisash_5
SELECT tennisash_1.Origin, tennisash_1.SumOfMdol, tennisash_2.SumOfKton
FROM tennisash_1 INNER JOIN tennisash_2 ON tennisash_1.Origin =
tennisash_2.Origin
UNION ALL SELECT tennisash_3.Destination, tennisash_3.SumOfMdol,
tennisash_4.SumOfKton
FROM tennisash_3 INNER JOIN tennisash_4 ON tennisash_3.Destination =
tennisash_4.Destination;

tennisash_6
SELECT tennisash_5.Origin, Sum(tennisash_5.SumOfMdol) AS SumOfSumOfMdol,
Sum(tennisash_5.SumOfKton) AS SumOfSumOfKton
FROM tennisash_5
GROUP BY tennisash_5.Origin;