Calculation in Access Form

F

Fav

My Inventory must decrease after every sale. I have tried this in the Table
property without success
 
A

Arvin Meyer [MVP]

Fav said:
My Inventory must decrease after every sale. I have tried this in the
Table
property without success

Having a table for purchases and a tables for sales allows a query to
subtract one from the other and alway have the right answer (except for
theft and spoilage).
 
K

KARL DEWEY

Are you using Transaction records? Purchase type transaction equal plus and
Sale transact equal a minus. Then have Inventory Adjustment, Reconciliation,
etc records.
 
A

a a r o n . k e m p f

use SQL Server and use triggers. HONESTLY.

Access doesnt' support this type of functionality.

If you're working for a _BUSINESS_ and they ask you to use a
_DATABASE_ default to SQL Server, not MS Access.
It's 10 times more powerful; cheaper; simpler-- SQL Server 'just
works'.

Access doesn't fit my needs; and the practice of using MDB is no
longer the reccomended route.

-Aaron
 
Top