Perform Calculation In Table

  • Thread starter Thread starter EE-IMM
  • Start date Start date
E

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