Calculation & to store a the result

[Faio]

Can some help me?

I have a table

measurement (Number, Double and 4dp)
wharfage(Currency, 2dp)

I created a Form

Measurement field
WCharge (calculated field) where Measument * 15.5 and I need the answer to
be stored in Wharfage field.

How can I do that?

 

[Allen Browne]

Do not store the value in the table.

Instead, create a query, and type this into a fresh column in the Field row:
WCharge: [Measurement] * 15.5

More information:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

 

[Keith Wilby]

Can some help me?

I have a table

measurement (Number, Double and 4dp)
wharfage(Currency, 2dp)

I created a Form

Measurement field
WCharge (calculated field) where Measument * 15.5 and I need the answer to
be stored in Wharfage field.

How can I do that?

Generally speaking you do not store calculations unless you need historical
data. Do the calculation in the form's query:

Wharfage: [Measurement]*15.5

If you really must store it then post back for some options.

Keith.
www.keithwilby.com

 

[Faio]

Thanks alot.

Can some help me?

I have a table

measurement (Number, Double and 4dp)
wharfage(Currency, 2dp)

I created a Form

Measurement field
WCharge (calculated field) where Measument * 15.5 and I need the answer
to be stored in Wharfage field.

How can I do that?

Generally speaking you do not store calculations unless you need
historical data. Do the calculation in the form's query:

Wharfage: [Measurement]*15.5

If you really must store it then post back for some options.

Keith.
www.keithwilby.com