Calculation in Access Form

  • Thread starter Thread starter Fav
  • Start date Start date
F

Fav

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

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).
 
Are you using Transaction records? Purchase type transaction equal plus and
Sale transact equal a minus. Then have Inventory Adjustment, Reconciliation,
etc records.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inventory Transaction Problem 1
Excel - Sliding decreasing scale (payroll tax calc) 2
Retrieve Column Header for Specific Data in a Row 3
combine multiple access templates into one 1
Enter Parameter Value in Access Form 0
Generate Sales Order Number 2
Calculating a grand total for an unbound control in a report 9
Need help to Simplify a Complex Calculation on a Form 0

Back
Top