Inventory control / on hand count
- From: "Beth" <Invalid@xxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 19 Apr 2006 22:51:16 GMT
Hello,
I am working on an inherited Access 2000 database for sale and purchase of
items. Right now it is setup with a sales table and a purchases table, each
with the quantity and cost of the item (either sold or purchased).
I need to create a report of all the inventory items with a count of the
number purchased, the number sold, and the number on hand. It seems like an
easy solution, but the attempts I have made to query this don't come out to
the right counts.
Any help you can offer is greatly appreciated.
Here is the setup I have.
tblSales tblPurchases tblItems
ItemID ItemID ItemID
Quantity Quantity ItemName
Price CostEach PreferredVendor
Thanks is advance,
Beth
.
- Follow-Ups:
- Re: Inventory control / on hand count
- From: MGFoster
- Re: Inventory control / on hand count
- Prev by Date: Re: Converting Query to VB
- Next by Date: Re: Linking Table Fields???
- Previous by thread: Re: My Head Hurts!! Parameter Date Query
- Next by thread: Re: Inventory control / on hand count
- Index(es):
Relevant Pages
|