Calculations in Form doesn't update main table

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

Guest

I created a table that I will refer to as my "master table". This table is
populated by a form that I have created for each individual sales manager.
Below is what I have done and the problem I'm having:

Form contains:

Auto calculations for fiscal year totals:
Default Value and Record Source are marked for each year
=[FY05Qtr1]+[FY05Qtr2]+[FY05Qtr3]+[FY05Qtr4]

It works great within the form - however it does not update the "master
table". The only place I have the formula is in my form under the Default
Value and Record Source and I assumed that it would automatically update the
master table. There are no relationships built because all I needed was the
one table to be populated.

Please help! I'm suppose to roll this out next week and it seems so simple
of a problem but I'm not an expert at Access.

Thanks to anyone

Debbie
 
I created a table that I will refer to as my "master table". This table is
populated by a form that I have created for each individual sales manager.
Below is what I have done and the problem I'm having:

Form contains:

Auto calculations for fiscal year totals:
Default Value and Record Source are marked for each year
=[FY05Qtr1]+[FY05Qtr2]+[FY05Qtr3]+[FY05Qtr4]

It works great within the form - however it does not update the "master
table". The only place I have the formula is in my form under the Default
Value and Record Source and I assumed that it would automatically update the
master table. There are no relationships built because all I needed was the
one table to be populated.

Please help! I'm suppose to roll this out next week and it seems so simple
of a problem but I'm not an expert at Access.

Thanks to anyone

Debbie
Click to expand...

You are working with Access, not Excel.
It won't update the table and it shouldn't.
Data derived from calculations need not be stored in a table.
Whenever you need the results of the calculation, re-calculate it, on
a form (as you are now doing), in a query, or in a report.
 
Thanks Fred!

Now I understand! I had the report created and recreated to reflect the
formluas - for some reason the first time I created it - it didn't run right
- but now it is!!! :)

Thanks for saving me!

Deb.

fredg said:
I created a table that I will refer to as my "master table". This table is
populated by a form that I have created for each individual sales manager.
Below is what I have done and the problem I'm having:

Form contains:

Auto calculations for fiscal year totals:
Default Value and Record Source are marked for each year
=[FY05Qtr1]+[FY05Qtr2]+[FY05Qtr3]+[FY05Qtr4]

It works great within the form - however it does not update the "master
table". The only place I have the formula is in my form under the Default
Value and Record Source and I assumed that it would automatically update the
master table. There are no relationships built because all I needed was the
one table to be populated.

Please help! I'm suppose to roll this out next week and it seems so simple
of a problem but I'm not an expert at Access.

Thanks to anyone

Debbie
Click to expand...

You are working with Access, not Excel.
It won't update the table and it shouldn't.
Data derived from calculations need not be stored in a table.
Whenever you need the results of the calculation, re-calculate it, on
a form (as you are now doing), in a query, or in a report.
Click to expand...
 
Back
Top