Hi - I have just started using Access & have came up with a problem & am
hoping someone can help me.

I have created a form & a few of the text boxes have formulas or
calculations but when I enter in the information it is not showing up in the
worksheet, the field is blank.

For example, the field NET TONNE calculation is (Gross Tonne - Tare), the
calculation works out on the form but does not show up on the worksheet.

Does anybody know why this is happening?

Trina L wrote:
> Hi - I have just started using Access & have came up with a problem &
> am hoping someone can help me.
>
> I have created a form & a few of the text boxes have formulas or
> calculations but when I enter in the information it is not showing up
> in the worksheet, the field is blank.
>
> For example, the field NET TONNE calculation is (Gross Tonne - Tare),
> the calculation works out on the form but does not show up on the
> worksheet.
>
> Does anybody know why this is happening?

It's an expression. Where in the table would you expect it to show up?

The result of expressions should not be stored. Just calculate the result
whenever you need it (just as you are now).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com