Super beginner, need some direction

[cweb85]

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.

[ranman256]

1st remember, access stores data vertically so you would want something like:

tFormula
----------
fields:
Forumula (say Cheetos)
Item (say Cheese Powder)
Pct (the percentage of the item)
VolWt (V or W for volumn or Wt)


tItems
----------
fields:
ITEM (cheese powder)
VOL
COST

Then once you have items, and formulas, you can produce horizontal (or vertical ) reports.