calculations in form are not entered into appropriate table


G

Guest

Calculations entered into property control source is not entered into the
appropiate table field. Show up as $0.00
 
Ad

Advertisements

R

Rick Brandt

TLM_QA said:
Calculations entered into property control source is not entered into
the appropiate table field. Show up as $0.00
A control is bound to a field in the table by entering a field name (and
just a field name) as the ControlSource property of that control. If you
have entered an expression as the ControlSource then it is no longer bound
to a field and there is no mechanism to get that value stored into the
table.

The good news is that calculations are not supposed to be stored in your
tables anyway. Just use the calculation that you already have on the form
anywhere you need that value displayed. If you don't want to enter the
expression multiple times then build a query based on your table and add the
expression as a calculated field in the query. Then just substitute the
query every place that you ordinarily use the table.
 
Ad

Advertisements

R

Rick B

You don't store calculations in a table. What if one of the fields that
makes up that calculation changes? How would access know to update the
calculated field?

When you need the calculated value, claculate it in your form, report, or
query.

For more details, read the previous posts on the topic. This is asked and
answered all the time. Do a search.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top