Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to save a calc value? I can't get a handle on it !

0 views
Skip to first unread message

Neville Garven

unread,
Mar 1, 1997, 3:00:00 AM3/1/97
to

using access 2.0

I have a quoting/invoicing database. The database consists of parts and
complete modules. The modules (nothing to do with access modules) consist
of many parts and the cost of the module is a calculated total, comprising
all the individual parts that make up that module. So far it works really
well.

When the database generates a quote/invoice, I need to save the calculated
total into a field, called ModuleTotal. I know that database theory says
you don't save calculated values, however I need to in this case. If I
don't save the value, and the cost of parts change, then everytime these
reports are re-run, different totals will be generated. Everyone will
become very confused and it won't work.

Specifically, I have a subform that lists the ModuleID, ModuleName,
ModuleTotal, and a couple of other fields. Currently, when the cursor
enters the moduleTotal field, a pop-up form appears with a list box,
showing module names and totals. How do I save the module total from the
pop-up list and have it appear in the ModuleTotal field on the subform.
Ideally, as soon as the user inputs the ModuleID, it would be better if the
ModuleName and ModuleTotal fields were automatically filled with the
appropriate values.

If you can help me out, then email to me and post to group. Needless to
say I have spent hours trying to automate the above without success. Would
sure appreciate some help on this one.
thanks

PS: I am not to experienced with all the jargon and code, so keep it
simple if possible...
regards

TDvN

unread,
Mar 4, 1997, 3:00:00 AM3/4/97
to

Without going into too much detail, you an do one of the following:
create a field with the control source as the calculated value ie.
=([Quantity] * [Price])
the field will not be updateable but will show the calculated value.

If you refer to values in a sub form use the following syntax:

forms![formname].[fieldname]

with this syntax you can address any open form, whether it
is a sub form or not.

Another method will be to run an update query once you exit the entry
form.

0 new messages