X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> How Do I Create A Comparison Report?, Access 2016    
post Dec 7 2017, 02:48 PM

Posts: 63
Joined: 22-August 17
From: Los Angeles

I have one table that has recipes and another table that shows the percentage of each ingredient in the recipe. I'd like to create a form that has let's say 10 boxes where I could type recipe1, recipe2, recipe3, etc.. Once this form has selections made, I would like to output a report that shows a comparison of [Raw material] and [Percent] like this picture. Now not every recipe is the same (hence the blank spaces next to some ingredients) so the raw materials should all be listed in one column while the percentages should show separately. I'm not sure how to do this, but I really feel like this is something Access can do. The reason I'm trying to do this is that there may be cost-saving options to explore. For example, if 3 recipes are being compared, I can see if 1 recipe is using a more costly ingredient than the other 2 and how much is being used.

Attached File(s)
Attached File  Screenshot.png ( 45.5K )Number of downloads: 0
Go to the top of the page

Posts in this topic

Custom Search
RSSSearch   Top   Lo-Fi    24th June 2018 - 01:55 PM