Table showing "0" in calculated field

  • Thread starter Thread starter dac
  • Start date Start date
D

dac

Hi,

I'm a newbie to Access. I would like Access to perform a % calculation.
As an example, The formula in the control source in properties reads
=[pymt]/[total income]. I also changed the number to %. It updates on the
form; however, when I look at the table only "0" appears. How do I get it to
map over to the table?

Thanks for your help.
Deb
 
You don't hold calculations in tables. Tables are raw data only and you use
forms/queries/reports to show calculations.
 
Build a query and base your form on that. In the query you can click
properties in each field. For example if you had three fields defined you can
set properties in each. Set the property of the field you desire to percent.
Now when you run the form it will already be in percent. Put a save function
in the form and it will save your results to your table.
 
Thank you that was very helpful.

Golfinray said:
Build a query and base your form on that. In the query you can click
properties in each field. For example if you had three fields defined you can
set properties in each. Set the property of the field you desire to percent.
Now when you run the form it will already be in percent. Put a save function
in the form and it will save your results to your table.

dac said:
Hi,

I'm a newbie to Access. I would like Access to perform a % calculation.
As an example, The formula in the control source in properties reads
=[pymt]/[total income]. I also changed the number to %. It updates on the
form; however, when I look at the table only "0" appears. How do I get it to
map over to the table?

Thanks for your help.
Deb
Click to expand...
Click to expand...
 
Back
Top