Stock On Hand

[Karan]

Dear all / Mr. Allen Browne,

As i said earlier that i want to maintain our inventory, i want to take the
Quantity On Hand. I have gone through your website and done the tables
accordingly. The Acquisition, Acquisition Detail and Stock Take Tables and
the remaining tables exist as mentioned(Northwind Traders Database)

1) Acquisition Table contains > Field1: AcqID(AutoNumber) Field2:
AcqDate(Date/Time) and Field3: AcqNote (Memo)

2) Acquisition Detail Table Contains > Field1: AcqDetailID(AutoNumber)
Field2: AcqID(Related to Acquisition Table) Field3: ProductID (Related to
Product Table) Field4: Quantity(Number) Field5: UnitPrice(Currenty)

3) Stock Take Table Contains > Field1: StockTakeID(Autonumber) Field2:
StockTakeDate(Date/Time) Field3: ProductID (Related to Product Table)
Field4: Quantity(Number)

I have created the reletionships also according to your sample Function.
Now i want to put the Function onHand. I don't know how to do that and also
do i need to build any query before i can calculate stock on hand. please
help me in this regard. I am under tremendrous pressure from all corners.
I want to do this, which will help me in a great deal. Any tips will be
highly valued.

Thanks and waiting for replies !!!

Thanks in advance

Karan

 

[simederi]

Dear all / Mr. Allen Browne,

As i said earlier that i want to maintain our inventory, i want to take the
Quantity On Hand. I have gone through your website and done the tables
accordingly. The Acquisition, Acquisition Detail and Stock Take Tables and
the remaining tables exist as mentioned(Northwind Traders Database)

1) Acquisition Table contains > Field1: AcqID(AutoNumber) Field2:
AcqDate(Date/Time) and Field3: AcqNote (Memo)

2) Acquisition Detail Table Contains > Field1: AcqDetailID(AutoNumber)
Field2: AcqID(Related to Acquisition Table) Field3: ProductID (Related to
Product Table) Field4: Quantity(Number) Field5: UnitPrice(Currenty)

3) Stock Take Table Contains > Field1: StockTakeID(Autonumber) Field2:
StockTakeDate(Date/Time) Field3: ProductID (Related to Product Table)
Field4: Quantity(Number)

I have created the reletionships also according to your sample Function.
Now i want to put the Function onHand. I don't know how to do that and also
do i need to build any query before i can calculate stock on hand. please
help me in this regard. I am under tremendrous pressure from all corners.
I want to do this, which will help me in a great deal. Any tips will be
highly valued.

Thanks and waiting for replies !!!

Thanks in advance

Karan