In the begining ...

[smask]

Hi!

I'm a complete beginner at Access and I have a problem.

I've got two tables one with "in" and one table with "out" from stock.

I want to make a query that tell me the actual amount of goods on stock.

I have four (five) variables:

(¤Cutomer ID)
¤Product type
¤Material
¤Color
¤Number of units

I want Access to sum up all products (same typ, color and material) in one actual inventory number (the sum of "in" and out"). Then the quary will be able to searce after ex all type X, color etc.

How will I do this?

/ Smask

 

[Bert666]

Stock

Hi there,

I suppose you would have to create a report and then group the items by The Item, then the color etc.

This way you would have what you want (I Think)

Bert.