Filling results of Expressions into Table

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

Guest

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!
 
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!
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DLookup and Nz 0
Expressions: Table Fields & Forms 1
Finding null 4
Error when trying to use calc field from Query 8
Replace text with related number 1
add variable table name to query results 4
ADDNEW in a Table (difference with Vista) 3
Data from Form to Subform to Table 2

Back
Top