[Solved] Calculation in Base

[Curt]

I want to do a simple calculation in a form or database. (Fee + Mileage = Total)
I have these setup already with no calculations included. I want to calculate the mileage based on (Miles * .50) or $.50 per mile driven. I want to be able to enter the fee in one cell and the miles driven in the next and have the end result be a total for the fee and miles driven at $.50 per mile. I am not sure why this should be do complicated. I used to be able to do in in MS Works within the database without all the extra work (queries and tables etc...)
Any help would be appreciated.

[F3K Total]

Hi,
a simple query needed

Code: Select all

SELECT "ID", "FEE", "MILES", "FEE" + ( "MILES" * 0.5 ) AS "TOTAL" FROM "Table1"

see example
R