not quite sure where to start

E

esparzaone

I have successfully built an inventory system up until now, I need help in
buiding a report based off of forms. It seems simple to explain but I cannot
build it.
all the information I need is off of my transaction table and product table.

Product table
ProductName, Description, Category, AccountNumber

Inventory Transaction Table
Date, ProductName, PurchaseOrderID, Price, #order, #Received, #use, waste,
AccountName, Location

What I want is a report - I need a parameter date i.e. 1/1/05 - 5/15/05
Then I need a criteria based on account name i.e. 1200, then by Location
i.e. Peshastin ( I want to type these things in before a report appears)

All I want my report to show is
Acct# Location Total Inventory Value
1200 Peshastin $12,000.00

I am basing my Total Inventory Value on what we had (have) as of that date
in a dollar value. So I would need to (behind the scenes) calculate - what
I had on hand up to that point +whatever we received - waste-use
I know what I want I don't know where to start. Any information is helpful
even if I have post this in the wrong spot.
Thanks
Zenia
 
Top