Perform Calculation In Table

[EE-IMM]

Hi there.
Hope someone can help me out here.

I have created a table, TableA. 2 of the Fields in TableA
are: "Date Opened" and "Date Closed".

I would like to create another field in TableA: "Date
Diff", that would automatically calculate the days
difference between "Date Opened" and "Date Closed" in
TableA. Can this be done?

Alternatively, I have created QueryA that is base on
TableA, and change field "Date Diff" to "Date Diff:[Date
Closed]-[Date Opened]".

Using the fields in QueryA, I created FormA with
RecordSource: TableA. It seems that i am only able to view
the calculation results for "Date Diff:[Date Closed]-[Date
Opened] in FormA. The calculation results are not shown in
TableA.

any help in this would be much appreciated! thanks.

rgds.

 

[chas]

Hi,

In general there is no point in storing the results of
calculations in a table when you can do them 'on the fly'
in a query. JET tables don't have a mechanism for this.
Using a query with calculations in as the RecordSource for
Forms/Reports is fine.

hth

chas