Functions In Access 2003

[Jeff]

I would like to know if MS Access will allow you to use "Functions" like MS
Excel to calculate some of the columns in the DB by using data from some of
the other columns. For example, I would have a cost per gallon in a "Cost"
column and gallons used in the "Gallons Used" column. I would like to have
the "Total Cost" column fill to be automatically filled in the Total column.

Thanks

 

[Douglas J. Steele]

You can use functions in Access, but you can't use them to calculate field
values in a table (nor should you).

There's no reason to store Total Cost in your table. Create a query that
calculates Total Cost, and use the query wherever you would otherwise have
used the table.