How to auto fill a mileage field

A

ajdaleo

I have a database for a medical transportation service. Here are the
relevant tables and fields:
Customer (table)- Last name, Town, Address, ect
Runs (table)- Date, Time, Destination, Miles, ect.
How do I programmatically fill in the miles field from a mileage grid.
(excel spreadsheet) Example: Town: Dover Destination: Lakewood -
Mileage=13 miles. Is it better to create a new table "mileage" in
access or link to excel spreadsheet? Any help or a link to a solution
would be welcomed.
Anthony Daleo (e-mail address removed)
 
L

Larry Daugherty

The burning question isn't the one you asked. More important might be
whether the data already exists in machine readable format, such as an
Excel spreadsheet???? If it does then that would be the way to go.
Traversing an Excel column to find your starting point from Access
and then locating the intersecting destination column is no big deal.

However, if the data doesn't already exist in machine readable form
then I'd definitely create it in an Access table.

Creating the data would be the bigger task.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with a mileage sheet 1
How do I create a link between columns from a data chart? 1
How do I return a mileage value from a row and column value 4
auto fill a field 3
Extract value from specific record to populate a new record 7
Add numbers if cell fill is a certain color; How To? 5
How to descibe Excel Mileage Chart table 2
I want access to fill a field with the current date 4

Top