Help with a table

[John K]

Hello,
I have a table with zip code, city, state, lat, and long. What I want to do is create a table that will give me the mileage between each record. I want to use record number 1 and find the distance to all the records within the table then go to record number 2 and so on until I complete all the records in the table. I know the formula to calculate the distance. I also understand how to set a calculate field although I have not tried this formula in the calculate field. I am just lost on how to set this up.
Thank for any help,
John

 

[John K]

Sorry I should have gave you some more info. The final table that I create I want for example feild 1 zip code, field 2 city, field 3 state, field 4 zip code, field 5 city, field 6 state, field 7 distance in miles. Thank you

 

[CJ_London]

Open a new query and drag your table into it twice. Do not link the two

One will be called YourTbl and the other YourTbl_1

Now simply drag zipcode, city, state from each table and do your calculation

So if you have 100 records in your table, this query will produce 1000 rows.

Simple as that!