Re: Sum totals not showing up in Queries or Reports
- From: fredg <fgutkind@xxxxxxxxxxxxxxx>
- Date: Wed, 11 Mar 2009 10:27:36 -0700
On Wed, 11 Mar 2009 09:29:01 -0700, NewAccessUser wrote:
Hi, new user here. I have created a table, which have fields for different
travel expenses. The last field is a total, and while in the design view of a
new form, I went to the properties of that "total" field and made the Control
Source to be the sum of the corresponding 6 fields I want summed. It DOES
produce the correct sum when shown on the form, however when I run a query or
make a report, the sum value doesn't show up when that field is listed. It is
blank. What am I doing wrong?
That is correct. It is not stored. You are attempting to improperly
use Access.
If you made the control source of a control bound to [Total] into an
expression, such as
=[FieldA] + FieldB]
how would Access know which field to store the data in as it is no
longer bound to [Total]?
Storing calculated data goes against the rules of database design.
Calculated data need not be stored in a table.
Anytime you need the result of a calculation, simply re-calculate it,
on a form, in a report, or in a query.
You can delete that field named "Total" from your table.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.
- References:
- Sum totals not showing up in Queries or Reports
- From: NewAccessUser
- Sum totals not showing up in Queries or Reports
- Prev by Date: Sum totals not showing up in Queries or Reports
- Next by Date: Re: Sum totals not showing up in Queries or Reports
- Previous by thread: Sum totals not showing up in Queries or Reports
- Next by thread: Re: Sum totals not showing up in Queries or Reports
- Index(es):
Relevant Pages
|
