help

[Samual]

is it possible to have a field in a table that performs a calculation
because i have a 'total cost' field in a table, and in the corresponding form the calculations are performed and it givesthe total cost, but this is not shown on the table???
appreciate any help

 

[Mile-O]

You shouldn't store the total cost in your table so you can delete the field.

You can calculate the total cost at any time in a form or report by using an expression in the controlsource of an object, and in queries you can create a calculated field.

 

[dcx693]

The form that has the total cost calculation is probably doing it the way Mile-O-Phile is describing it. It's a control doing the calculation on the form not a field in your table.