New to Access 97, have to make mileage database

[Guest_imported]

I work in a school district containing 13 schools. We get paid to drive from one school to another when we have service calls. Right now we just use a sheet of paper to log our mileage from school to school. (we have a table of mileages, like the city mileages you find in maps)

How would I set up an access database to do that job easier?
The user would select two schools in a form and click "Go"
How should I set up my table?

 

[HOMMER]

do you want to have the user to select start school to end school and show the mileage? Or do they go from home to a school and need to show this mileage?

 

[ryanku]

Go to

http://support.microsoft.com/support/kb/articles/Q182/5/68.ASP

Download the QRYSMP97.exe (The queries sample database)

Run the database then open qryNextRec_Dlookup or qryNextRec_VBA Query.

hope that's the answer for your problem. ^_^

ryan
ryanku@hotmail.com