Hallo

Is there someone here who could help me?
I don’t anything about access, but I need a template which I could use
when I buy / sell parts.
I also should know how many of the parts I have in the warehouse.

I don’t know if I should use three tables one for both buying and
selling parts, and one for keeping me updated on how many of these
parts is in the warehouse.

The information I need in the table is Date, Ware description,
Quantity, Price each, Costs, Total,

Poul

--

Poul Erik wrote:

template. There are Order Mgt and Inventory Mgt database templates you
can dl from MS.

You could build Excel files and then import (File/GetExternalData/Import
or Link) them. Import you can modify the data, link is Read-only.

If you don't know anything about Access, you might want to consider
hiring someone that can put it together. Maybe use CraigsList under
computer gigs.

On Mar 23, 11:04*am, "Poul Erik" <> wrote:
I would use the following tables, not need to capture totals since it
can be
calculated using a query (or two)
tblItem
itemId
description
qtyOnHand

tblItemTransaction
transactionId (autonumber)
itemId
transType (S - sale, P - purchase, A - adjustment)
transDate
transQty
transCost
transPrice

qryTransQty
-----------
select itemId
, sum(IIf(transType = 'S', -transQty,
IIf(transType = 'P', transQty,
transQty) as tQty
from tblItemTransaction
group by itemId


qtyQtyOnHand
------------
select tblItem.itemId
, tblItem.qtyOnHand + qryTransQty.tQty as onHand
from tblItem left join
qryTransQty on tblItem.itemId = qryTransQty.itemId

the reason, tblItem as qtyOnHand, it allows you to flush transactions
out of tblItemTransaction and store the next quantity as qtyOnHand

of course, the flushing activity needs to deal with costing, be it
average cost, fifo cost, last cost,....

Roger wrote:


Hallo Roger and thank you.

But as I write I'm totaly novice on ms-access, I bought a little book
for beginner, but there was nothing i could use in this execpt for some
simple tables, query and reports.

I know it is much to ask about, but is it possibly you could put your
information in a db and mail it to me for analysing.

Poul
givskov(nospam)@adslhome.dk
--

Roger wrote:

Hello Roger
As I write I'm totaly newbee in access, is the first two parts tables,
and the last tow sections is this queryes?

Poul

Is this table one?

tblItem

and this table two?

On Mar 25, 11:57*pm, "Poul" <givskov(nospam)@adslhome.dk > wrote:
yes to all your questions

Roger wrote:
Thank you Roger you have been at great help.

Poul

--