Table problem

[imlost2]

working on inventory in access.. but got stuck again. well hope to explain this where we all can understand. When you put-away an item"7001" say in row"S01" it will add 40 to inventory. If you put-away an item"7601" say in row"S02" it will add 45 to inventory. Another problem is row"S01" can only have 22 entry's in it of the same item number. Would like a report to look like this.
Example:
Item row packed-date quantity


7001 S01 12/12/11 40
7001 S01 12/12/11 40
7601 S01 12/12/11 45
7601 S02 12/12/11 45

[June7]

There is no relationship between project count and Putaway tables. Can't retrieve the quantity by joining. So either fix the table to list ALL possible item numbers then join the tables on the common field or use an expression with DLookup or a custom function to return the appropriate value.

Rats! DLookup test not working. That is because 7*** is found before 78** so any Inventory Putaway value beginning with 7 will always return the quantity 40