Hello all!
This is my first post, so bear with me.
I need to create a report that will track the inventory of some pieces of equipment I have. The report must only track the Part Number, Location, and quantity.
Problem is, Part A can have Qty. 2 in location A, Qty. 4 in location B, and Qty. 0 in location C.
Also, Location A may have 2 of Part A and 3 of Part B but 0 of Part C.
Basically what I want to do is generate a report based off of an active table that will give me the part number and location of every "asset".
From this I would like the report to be in somewhat of the following format:
Code:
Part Number | Location A | Location B | Location C | etc
1234567890 | 1 | 4 | 0 | ...
0987645321 | 0 | 3 | 2 | ...
7894561230 | 4 | 0 | 2 | ...
I can generate the report I want by using "hard-coded" labels and using the following formula for the numbers inside of the report:
Code:
=sum(iif([MODEL]=1234567890,iif([LOCATION]="A",1,0),0))
However, I want to do that by not putting in every model number and every location because they can change, and I would have to re "hard-code" my report everytime I edited a location or added a part number.
Any help would be greatly appreciated.
Thanks