Calculate distance driven on an expense report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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------
 
distance said:
Fields Date, starting mileage, ending mileage = distance driven, seems
simple,,,,


BUT HOW!!!

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


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.
 
Back
Top