Need help to save record in the table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

riyaz - 25 Aug 2006 06:53 GMT

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 .

Reply to this Message

John Vinson - 25 Aug 2006 21:09 GMT

>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.

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]

Reply to this Message

riyaz - 26 Aug 2006 01:38 GMT

thanx for your suggestions

riyaz

> >i have access form which is used to calculate values for the different
> >types of formula..(Type1 type2 ,etc..)
[quoted text clipped - 16 lines]
>
> John W. Vinson[MVP]

Reply to this Message