By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,297 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

Subtract recordset

P: n/a
Friends,
Im 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.
May 25 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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,
Im 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.

May 26 '06 #2

P: n/a
* PC Datasheet:
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

--
To anyone reading this thread:

It is commonly accepted that these newsgroups are for free
exchange of information. Please be aware that PC Datasheet
is a notorious job hunter. If you are considering doing
business with him then I suggest that you take a look at
the link below first.

http://home.tiscali.nl/arracom/whoissteve.html

Randy Harris
May 26 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.