Filling results of Expressions into Table

R

RussellH

Hi,

I'm hoping someone out there can help me. I have created an expression in
the Form Design View (=[Field1]/[Field2]), and want to store the result of
this expression into a field in a table so I can display the value in a
report. I can't seem to store this value though. The result appears
correctly in the Form View, but the associated field in the Table (and
Report) is always empty.

Any help would be greatly appreciated, as this is driving me mad!
 
J

Jerry Whittle

In general you should never store something in a table that can be figured as
needed.

In this case put something like =[Field1]/[Field2] in the report!
 
I

i_takeuti

RussellH said:
Hi,

I'm hoping someone out there can help me. I have created an expression in
the Form Design View (=[Field1]/[Field2]), and want to store the result of
this expression into a field in a table so I can display the value in a
report. I can't seem to store this value though. The result appears
correctly in the Form View, but the associated field in the Table (and
Report) is always empty.

Any help would be greatly appreciated, as this is driving me mad!
Click to expand...
 
Top