HELP! Please. :)

M

Maige

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
 
R

Rick Brandt

Maige said:
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
Click to expand...

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.
 
Top