HELP! Please. :)

[Guest]

I'm new to Access and here's my problem...
I made a Form from a Table to keep track of inventory. I wanted to make a
calculation field to figure out profits. In the field control properties I
changed the control source to an expression which worked fine on the form,
however, it doesn’t record the data in the table – what am I doing wrong?
Thank you!
- Maige

 

[Rick Brandt]

I'm new to Access and here's my problem...
I made a Form from a Table to keep track of inventory. I wanted to
make a calculation field to figure out profits. In the field control
properties I changed the control source to an expression which worked
fine on the form, however, it doesn't record the data in the table -
what am I doing wrong? Thank you!
- Maige

Calculations (and the results of them) do NOT belong in tables. Just use your
expression any place you need that value. Tables should only hold base data.

 

[Guest]

Thanks anyway, I figured it out myself!