You have chosen to sponsor your bid up to a maximum amount of .
I have a spreadsheet that contains tons of data related to our shop's inventory: part numbers, vendor info, pricing, etc... I need that spreadsheet to be turned into Access Tables as needed and then a form created that allows me to look up inventory items via any of several fields and edit information for that line item and save. I also need a form that allows me to look up line items by any of various fields and then enter a quantity and have that quantity of that particular line item added to a BOM (bill of materials). Basically we build assemblies and know that it takes 7 of line item X and 9 of line item Y and 12 of line item Z to make one assembly...so we need to be able to select those and have the ability to either print that BOM or export it to an Excel spreadsheet at the end...preferably both. This should be very similar to an Order / Order Details form / subform setup...I just haven't played with Access enough in recent years to remember how to do the look up queries, etc...so I prefer to sub it out. I have attached a sample Excel spreadsheet that has the fields for the inventory. When looking up inventory line items, I would like to sort by category then sub-category to get me closer to the item that I am looking for. The final BOM report should have room for a Project Name, customer contact information, then a list of all the line items included in the BOM with extensions of the price and cost per line item as well as a total price and cost for the whole BOM at the bottom. I need this done by Sunday 4pm PST...so if you can't do it by then please don't bother bidding. It should be really quick and pretty simple. Nothing fancy in appearance...just need the functionality.