So I'm a moderate to advanced Excel user, but have little experience with Access (other than a few sessions trying to teach myself). I would really appreciate some general pushes in the right direction. My need is super simple to an average Access user I'm sure. I can easily keep the recipe page in access if I can get this done. As it is I have to have a batch ticket built for every formula, this takes too much time (see below).
I have a database built into excel (I'm sure many of you wouldn't call it a DB). Two of my sheets operate as follows, one sheet contains a number of records corresponding to recipes for products. I have to take these recipes and make printable tickets, similar to forms or reports, that the warehouse guys can follow to make the products. Right now, I have a second sheet in excel that I have a format for the printable ticket. I use Vlookups to populate the ticket. But I still have to input enough data that mistakes can happen, and it's time consuming. Right now the recipe sheet has fields populated with percentages in each record. I want to take those percentages, multiply it by the "batch size" for that particular order, convert it to some other unit, And then get a report etc that shows me each ingredient with how much. If I could build one or two form/report formats that could be used on any recipe I would save a lot of time.
Help is greatly appreciated.