Hi,
I work at a small food service business where we make a number of different deli salads and similar things. One of my jobs is to price out how much each different salad costs to make. What I currently use is an Excel spreadsheet where I manually enter the cost of each ingredients and amount used to figure out cost. However, I would like to make an Access database to do this instead, where I have a form where I pull up a recipe, select all the ingredients and then have the form automatically calculate the cost.
I have made all the tables I will need, but I'm having trouble making the form where the costs are calculated. The calculating form needs to pull information from several different tables (materials, labor, and ingredients) to calculate the total cost of a recipe, and I'm having trouble figuring out a.) how to get all of that info on one form and b.) getting the form to calculate the correct values.
I have looked for templates that do something similar but I have had no luck. I would appreciate any suggestions, advice, or gentle shoves to resources on where to figure out how to do something like this!
Thanks!
Nick