Transfer Data to a table

[SGTPEP]

I have created a form that enters incomes and expenditure for events.

I have added fields that now calculate the totals and and final profit and
loss.

Access doesn't automatically add the calculated data in the field to the
table.

I know this is against the principles of access database but how do i add
this calculated data to the table

Thanks

 

[mscertified]

Calculated data should not be placed in the table; this breaks the rules of
normalization. Perform the calculations whenever the data is to be viewed or
printed.

 

[fredg]

I have created a form that enters incomes and expenditure for events.

I have added fields that now calculate the totals and and final profit and
loss.

Access doesn't automatically add the calculated data in the field to the
table.

I know this is against the principles of access database but how do i add
this calculated data to the table

Thanks

I suppose the real question is why, if you know it goes against the
principals of access database design, you still want to do this?