Search results

Thanks for coming up with that. I actually came up with a query that shows current inventory status (or as of a date) like yours does, but yours is cleaner. The part that I'm really struggling with is creating a report for accounting though. I need it to show how many pallets were stored...

I like the idea of less tables. My question is, if I use a single table for inventory change records, what would a query look like to calculate storage between dates?

I own a business that (gross oversimplification) receives pallets of goods into our warehouse, stores them for a time, and ships them out. We do not own the goods, we're just a storage facility. We have lots of other software that handles orders and accounting and everything that makes our...

The packing lists were given to me by my customer. It is just 3 columns of data, the shipment id, UPC code, and quantity. Since the app is just a one time use sort of project, it's not that important to determine the logic behind the packing list. Ideally, when I scan a barcode it will tell...

Hi Everyone, I own a small business and took on a project that is outside the scope of what we normally do, and I'm thinking Access is a tool we can use to solve this problem and move on. Here is the situation: We have around 2,000 items in our warehouse right now (650ish unique) that need to...