You arrogant dumb@$$.
I just came across the following in the Microsoft.Public.Access. Forms
newsgoup. Do you also have the same arrogant comment about all these
responders too?
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com
By OP ----- What must I do to save the total?
You must do nothing at all. It's common sense not to store values from
totals. What you do is save the 'operants' and the outcome should be
calculated as you did via a textfield or either a field in a query. When
using a query you don;t have to look in the table because you don't save the
calculation.
--
Maurice Ausum
Is there a reason you need to store the total amount in the table, though?
Can't you just calculate the total from the other fields, thereby negating
the need to redundantly store the total?
--
Ken Snell
<MS ACCESS MVP>
Generally, you should not store calculated values ... what happens if one of
the root values change, and (for some reason) the total doesn't get updated?
Since you're obviously storing the root values, just calculate the
TotalAmount when needed, using the formula you list above.
Scott McDaniel
Don't.
Storing derived data such as this in your table accomplishes
three things: it wastes disk space; it wastes time (almost
any calculation will be MUCH faster than a disk fetch); and
most importantly, it risks data corruption. If one of the
underlying fields is subsequently edited, you will have data
in your table WHICH IS WRONG, and no automatic way to detect
that fact.
Just redo the calculation whenever you need it, either as a
calculated field in a Query or just as you're now doing it -
in the control source of a Form or a Report textbox.
John W. Vinson [MVP]
You have received a lot of good advice. Pay particular attention to Johm
Vinson. His comment pretty much covers it.
------
Dave Hargis, Microsoft Access MVP
Thanks to you all.
I will not save the total.
I will not save the total.
I will not save the total.
Seriously, I appreciate all your input.
By OP ------
"Bob Quintal" <rq******@sPAmpatico.cawrote in message
news:Xn**********************@66.150.105.47...
"Steve" <so***@private.emailaddresswrote in
news:IJ*******************@newsread2.news.pas.eart hlink.net:
>Re: Desc field
It is still a mistake to have the Desc field in your table!!
You undoubtedly will regret it later.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And
Word Applications
re******@pcdatasheet.com
You arrogant dumb@$$. The OP is using the calculation as a default
value for his description field. He may alter or add to the
contents thereof. It is required in any sane MRP or equivalent
system.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from http://www.teranews.com