Hello I am ORS,

I have to create a Table where some fields are formula related. I need
these fields to create a database. Could you help me to overcome this
problem. Everything looks OK on the form, but the formula related
fields are always empty (not collecting the data).
Please help.

You would need to give us some details if you want help.

If you are saying that the calculated value is not being saved to the table,
then that is correct. You should not store calculated values in a table.
You store the numbers that make up the calculation, but you do not *also*
store the calculation.

If you are saying the calculated value is not appearing in your form, then
you would need to tell us what you have in the unbound control of your form.


--
Rick B



<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello I am ORS,
>
> I have to create a Table where some fields are formula related. I need
> these fields to create a database. Could you help me to overcome this
> problem. Everything looks OK on the form, but the formula related
> fields are always empty (not collecting the data).
> Please help.
>

Hi! Rick,

I am providing you some more info that you asked me for.
The calculated value does appear on the form, but how do I store the
number that make up the calculation?
I have still not understood what you meant!
I have a table with fields

Fields DataType
EntryPrice Number
StopLoss Number
InitialRisk Number

On the form, I have these 3 text boxes inserted with the fieldlist.
Now Textbox InitalRisk has a formula =(EntryPrice - StopLoss)*10000
When the form is run this value is displayed; but on checking the table
this value is not written into its respective field in the table. Will
you please explain how to get this data into the field.

Thanks
ors

Hi! Rick,

Have'nt had any feedback! You asked for some more details.

I am providing you some more info that you asked me for.
The calculated value does appear on the form, but how do I store the
number that make up the calculation?
I have still not understood what you meant!
I have a table with fields


Fields DataType
EntryPrice Number
StopLoss Number
InitialRisk Number


On the form, I have these 3 text boxes inserted with the fieldlist.
Now Textbox InitalRisk has a formula =(EntryPrice - StopLoss)*10000
When the form is run this value is displayed; but on checking the table

this value is not written into its respective field in the table. Will
you please explain how to get this data into the field.


Thanks
ors

Calculated values shouldn't be stored in the table.

As fellow Access MVP John Vinson likes to say "Storing calculated data
generally accomplishes only three things: it wastes disk space, it wastes
time (a disk fetch is much slower than almost any reasonable calculation),
and it risks data validity, since once it's stored in a table either the
Total or one of the fields that goes into the total may be changed, making
the value WRONG."

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi! Rick,
>
> Have'nt had any feedback! You asked for some more details.
>
> I am providing you some more info that you asked me for.
> The calculated value does appear on the form, but how do I store the
> number that make up the calculation?
> I have still not understood what you meant!
> I have a table with fields
>
>
> Fields DataType
> EntryPrice Number
> StopLoss Number
> InitialRisk Number
>
>
> On the form, I have these 3 text boxes inserted with the fieldlist.
> Now Textbox InitalRisk has a formula =(EntryPrice - StopLoss)*10000
> When the form is run this value is displayed; but on checking the table
>
> this value is not written into its respective field in the table. Will
> you please explain how to get this data into the field.
>
>
> Thanks
> ors
>