Transfer Data to a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
Click to expand...

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