Newbie: Stock Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

Need your help on putting a stock field on the report
Say I have this table tblTool with fields below
- fldToolDesig
- fldToolPowe
- fldToolType (male or female
- fldToolID (pk

What I'd like to show on the reports is how many tools I have in the stock with the same "fldToolDesign and fldToolPower" and the same "fldToolDesign, fldToolPower and fldToolType

Example
There are 4 records on the tabl

fldToolDesign fldToolPower fldToolType fldToolI
- DesignA PowerA Male 00
- DesignA PowerA Male 00
- DesignA PowerB Male 00
- DesignB PowerB Female 00

So what appears on the reports should be
fldToolDesign fldToolPower fldType Stoc
- DesignA: 3
PowerA Male
Female
PowerB Male
Female
- DesignB:
PowerA Male
Female

Since I don't have table that store stock info, I have to calculate the stock by counting the records appearance according to the criteria I have set
Any ideas would be much appreciated

Cheers
Djoezz
 
Rather than adding a field, consider using a query to dynamically calculate
your counts.
 
Back
Top