You do the calculation in a query that includes your table that contains
your parts inventory and your sales detail table.
TblPart
PartID
PartNum
PartName
PartInventory
TblSale
SaleID
SaleDate
CustomerID
TblSaleDetail
SaleDetailID
SaleID
PartID
SaleQuantity
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
re******@pcdatasheet.com
"Fabian" <u22247@uwe> wrote in message news:60c803e1883b0@uwe...
Friends,
I´m making a basic system for sale spare parts cars and have a problem to
subtract my new stock against sale on the day.
Is possible use a basic consult and foms or necessary I need specials
formulas in my system.
thanks.
Fabian.