Manufacturing Inventory Report

%3CLINGO-SUB%20id%3D%22lingo-sub-1863511%22%20slang%3D%22en-US%22%3EManufacturing%20Inventory%20Report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1863511%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20pretty%20new%20to%20the%20whole%20Access%2FDB%20scene%2C%20so%20I'm%20not%20sure%20what%20I'm%20doing%20wrong%20and%20I%20don't%20have%20all%20the%20time%20in%20the%20world%20to%20try%20and%20fix%20this%20problem%20myself.%26nbsp%3B%20We%20are%20trying%20to%20do%20an%20inventory%20count%20soon%2C%20so%20I%20used%20the%20inventory%20database%20template%20included%20with%20access%20to%20try%20and%20get%20me%20up%20and%20running%20quickly.%26nbsp%3B%20We%20store%20parts%20on%20racks.%26nbsp%3B%20There%20are%20multiple%20different%20sections%20of%20racks%20for%20different%20purposes.%20I'm%20the%20electrician%2C%20so%20I%20am%20using%20the%205%20racks%20by%20me%20for%20testing%20purposes.%26nbsp%3B%20Each%20rack%20has%20multiple%20shelves.%26nbsp%3B%20Each%20shelf%20has%20multiple%20bins%2Fdrawers.%26nbsp%3B%20Not%20sure%20if%20a%20report%20is%20even%20the%20right%20way%20to%20go%20about%20this%2C%20but%20that's%20why%20I'm%20here.%26nbsp%3B%20I%20added%20fields%20for%20Rack%2C%20Shelf%2C%20and%20Bin%20to%20the%20inventory%20table.%26nbsp%3B%20I%20entered%20%22Electrical%22%20in%20the%20location%20field%20on%20each%20record%2C%20as%20the%20number%20scheme%20for%20different%20locations%20restarts%20at%20each%20location%20(Electrical%201%2C%20Parts%20room%201%2C%20etc.).I%20then%20entered%20the%20appropriate%20Rack%20%23%2C%20Shelf%20%23%2C%20and%20Bin%20%23%20on%20each%20record.%26nbsp%3B%20When%20trying%20to%20run%20a%20report%20using%20the%20wizard%2C%20the%20first%20one%20was%20almost%20what%20I%20was%20looking%20for%2C%20but%20the%20colors%20I%20specified%20to%20draw%20attention%20to%20each%20new%20rack%20or%20shelf%20weren't%20always%20displaying%20properly.%26nbsp%3B%20It%20appeared%20to%20be%20random%20occurrences%2C%20and%20I%20double-checked%20that%20I%20hadn't%20made%20any%20data%20entry%20errors.%26nbsp%3B%20I%20would%20also%20like%20the%20report%20to%20print%20each%20shelf%20on%20a%20separate%20page%20so%20I%20can%20attach%20it%20to%20the%20corresponding%20physical%20shelf%20to%20simplify%20the%20job%20for%20each%20person%20that%20will%20be%20doing%20the%20counting.%26nbsp%3B%20Any%20ideas%20on%20how%20I%20would%20I%20make%20all%20this%20happen%3F%26nbsp%3B%20Hope%20I%20explained%20everything%20clear%20enough.%26nbsp%3B%20I%20appreciate%20any%20input.%26nbsp%3B%20Thanks.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETried%20to%20post%20the%20file%2C%20but%20I%20get%20%22%3CBR%20%2F%3EThe%20attachment's%20inventory1.accdb%20content%20type%20(application%2Fmsaccess)%20does%20not%20match%20its%20file%20extension%20and%20has%20been%20removed.%22.%26nbsp%3B%20So%20idk.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1863511%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hi all-

 

I'm pretty new to the whole Access/DB scene, so I'm not sure what I'm doing wrong and I don't have all the time in the world to try and fix this problem myself.  We are trying to do an inventory count soon, so I used the inventory database template included with access to try and get me up and running quickly.  We store parts on racks.  There are multiple different sections of racks for different purposes. I'm the electrician, so I am using the 5 racks by me for testing purposes.  Each rack has multiple shelves.  Each shelf has multiple bins/drawers.  Not sure if a report is even the right way to go about this, but that's why I'm here.  I added fields for Rack, Shelf, and Bin to the inventory table.  I entered "Electrical" in the location field on each record, as the number scheme for different locations restarts at each location (Electrical 1, Parts room 1, etc.).I then entered the appropriate Rack #, Shelf #, and Bin # on each record.  When trying to run a report using the wizard, the first one was almost what I was looking for, but the colors I specified to draw attention to each new rack or shelf weren't always displaying properly.  It appeared to be random occurrences, and I double-checked that I hadn't made any data entry errors.  I would also like the report to print each shelf on a separate page so I can attach it to the corresponding physical shelf to simplify the job for each person that will be doing the counting.  Any ideas on how I would I make all this happen?  Hope I explained everything clear enough.  I appreciate any input.  Thanks. 

 

Tried to post the file, but I get "
The attachment's inventory1.accdb content type (application/msaccess) does not match its file extension and has been removed.".  So idk.  

0 Replies