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 - 08 Sep 2007 17:57 GMT
> 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
[quoted text clipped - 3 lines]
> 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.

Signature
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Maige - 08 Sep 2007 18:22 GMT
Thanks anyway, I figured it out myself! :)
> 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
[quoted text clipped - 3 lines]
> Thank you!
> - Maige