Help with inventory and price database

[Udyr2g]

Hello,


I'm new to access and I'm having a hard time figuring out something. I don't really know how i would explain this so I'm gonna give you guys an example.
I would do monthly updates on inventory counts. I would update the DB when I purchase more inventory and put in at what price they were bought at.
I would use inventory from oldest to newest
So at the beginning of the month I have 100 CD's that were bought at $1 each and during the month I buy 100 at $ 2 and at the end of the month I would do my regular inventory check. And I have 150 CD's in inventory.
So how would I design this in access to see how much my inventory is worth.

Thanks in advance.

[ranman256]

tbl: tInv
(fields):
[ItmType] (cd)
[Qty]
[PurchDate]
[Cost]


qry: qsInvSum
Sum all CDs in the in the table / cost

[KRegal]

It may be easiest to add one more field to the above mentioned designed of data type "Calculated". This field would be equal to [Qty]*[Cost], and a query could take the sum of this field.

Is this the real King2g??! Please don't drop bows on these people. We respect it.

[orange]

See this

Good luck with your project.

[Udyr2g]

Thanks for the help
Appreciate it