Copying calculation filed from another table

[2624]

Hi all,
I am working in Access 2000.
I would like to copy calculated field from one table to another table.
My database’s relations set-up with Act_no field through out the database.

I have main form name is Activiy Tracking based on Activity Query(ipbs_test(table) + Justop_plantable(table)+Template Query_results(table which collects all the search results)) .
I have another form name is Transfer Info which is based on transfertablequery (transfer_table + Template query results).

Just_opplantable and transfer table has one to many relations.

I have calculation field in the Transfer Info forms’ footer; name is Transfertotal_ctrl Control source; =Sum([trf_amt]) and this total save in to transfer table on the form event before update Me.totaltransfer_amt = Me!Transfertotal_ctrl

I would like to copy this field; totaltransfer_amt (from the transfer_table) in to Transfertotal field in the just_opplantable (which I create this field in the Justop_plantable for displaying this calculated field from transfer-table).

Thank you so much in advance.

 

[jhall156]

You can accomplish this by creating the field in the target table and then running an update query (check the online help). I must tell you that storing calculated values like this (particularly a simple total) is a bad idea and a violation of normal form. JHall

 

[2624]

I would like to know why is a bad idea storing calculated field in the table or form. The reason I would like to store the calculated field is; I have one to many relations for each Activity with four different tables(transfer table, Travler table, contractor table, publication table). When I try to run a report for the each activities total cost multiplies everything with how many times each table have activity(gives me wrong total). I though if I can get only total totaltransfer_amt + totaltravler_amt+... I will get right total for each activity. Please help. am I doing this totally wrong?

 

[jhall156]

Is this Access 2000? If so can you zip it and email it to me? JHall

 

[2624]

I will try to email you. What is your email address. Thank you taking your time .

 

[jhall156]

jhall@worthltd.com JHall