Calculated Field Shows No Value in Report

[kelley.l.turner]

Hi all,

I am very new to MS Access so please bear with me! I have created a
simple calculated field in my data entry form, yet when I view my data
table or try to generate a report based on this calculated field, no
value is posted. How/where do I get my calculated values to also show
up in the tables and reports?

Thanks,
Kelley

[Rick Brandt]

ke*************@gmail.com wrote:

Hi all,

I am very new to MS Access so please bear with me! I have created a
simple calculated field in my data entry form, yet when I view my data
table or try to generate a report based on this calculated field, no
value is posted. How/where do I get my calculated values to also show
up in the tables and reports?

Thanks,
Kelley

In tables? You don't. You are calculating the value on your form without
needing to store it and that is how you should do it. Put the same calculation
into any other form, report, or query that you need to see it in. In your table
you should delete the field where you thought you needed it.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[luanhoxung]

Are u sure the calculated field that have 'control soure" is some fields of
table u want to record.
May be the calculated field is just control of entry form. it only display
some information such as "TOTAL", ect.
show more details of ur data for get anybody's help.

[Larry Linson]

"luanhoxung" wrote

Are u sure the calculated field that have
'control soure" is some fields of table
u want to record.

Calculated _Fields_ are in Queries; calculated Controls are in Forms --
because the calculation is defined in the Control Source, they canNOT be
bound to a Field in the Form's RecordSource.

May be the calculated field is just
control of entry form. it only display
some information such as "TOTAL", ect.
show more details of ur data for get
anybody's help.

That's not a "may be," it is just not possible for a calculated Control to
be bound.

If that value can be calculated when needed (not necessarily, but usually,
from other values in the Record) then it SHOULD NOT be stored.

If it can't be, then (1) you can perform the calculation in an appropriate
event, in VBA code, and set the value of a bound Control or (2) you can have
an invisible Control bound to the Field in the RecordSource and set the
value of the calculated Control into the invisible Control to be saved.

Larry Linson
Microsoft Access MVP