Need help to save record in the table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi
i have access form which is used to calculate values for the different
types of formula..(Type1 type2 ,etc..)
my aim is to save all the inputs ,type of formula & the calculated value in
a table.

for eg : Resulting table may look like this

Formula x y z calculatedvalue

Type1 2 945 10 somevalue
Type3 512 6 612 somevalue
Type2 7 23 899 somevalue


where X , Y ,Z -- > input parameters ,,,
type --> formula name used
Calculatedvalue --> Result

please help me to give the sample condition for saving the all the records
to the table shown in the example structure above


thanks .
 
i have access form which is used to calculate values for the different
types of formula..(Type1 type2 ,etc..)
my aim is to save all the inputs ,type of formula & the calculated value in
a table.
Click to expand...

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]
 
thanx for your suggestions

riyaz

John Vinson said:
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]
Click to expand...
 
Back
Top