I am putting together a menu that must have certain limits. For instance, a meal, that must consist of 1 meat, 1 veg, 1 fruit, 1 grain and 1 milk, must be between 550-650 calories and cannot cost over $1.10. How and where would I enter these limits?
Also, is there a way to ask Access to look through all the data in my table and return all possible combinations of the meal requirements that fall within the limits?
Thank you!![]()