By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,122 Members | 1,689 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,122 IT Pros & Developers. It's quick & easy.

Calculated Field Shows No Value in Report

P: n/a
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

Oct 3 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Oct 3 '06 #2

P: n/a
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.

Oct 3 '06 #3

P: n/a
"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
Oct 3 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.