Calculate distance driven on an expense report

[Guest]

Fields Date, starting mileage, ending mileage = distance driven, seems
simple,,,,


BUT HOW!!!

can anyone please advise how to calculate mileage drive in a table?????


respond and I will send you a copy of the table------

 

[Marshall Barton]

Fields Date, starting mileage, ending mileage = distance driven, seems
simple,,,,


BUT HOW!!!

can anyone please advise how to calculate mileage drive in a table?????

No can do. Tables are for storing data, not for displaying
calculated values. For that matter, the rules of database
table stucture (called Normalization), state that a value
that can be derived from other values in the same record
should **never** be saved in the record.

As a matter of good design practices, you should never
display a table directly where users can see it. Instead
you should create a form to display the table values, it is
trivially easy to calulate your distance value using an
expression in a text box's control source property.