using formulae in access table

[Guest]

I am trying to put an expression in a 3rd field to subtract "quantity
remaining" from "quantity" using the default value i.e whatever happens in
the other two fields i want the default value of the third field to be
automatically calculated. Any ideas folks
Ted.

 

[Rick B]

As posted all the time in these newsgroups, you don't store a calculated
value in the table. You calculate it in your forms, reports, or queries.
Read the previous posts on calculated values if you need more details.
There are hundreds of them out there with examples and reasons not to do it.

 

[Guest]

As posted all the time in these newsgroups, you don't store a calculated
value in the table. You calculate it in your forms, reports, or queries.
Read the previous posts on calculated values if you need more details.
There are hundreds of them out there with examples and reasons not to do it.

 

[Guest]

As posted all the time in these newsgroups, you don't store a calculated
value in the table. You calculate it in your forms, reports, or queries.
Read the previous posts on calculated values if you need more details.
There are hundreds of them out there with examples and reasons not to do it.

--
Rick B






Tanks Rick

I'll try a different tack . I was convinced it could be done.
Ted