Hello all,
I'm creating a nutritional data base, for a nutritionist to create diet programs and receive a summarized report of nutrients. among all the queries and tables, I think the following are the ones that matter:
- I have table "tbl_Nutrients" which has each nutrient that needs to be summarized (20 rows)
- I have query "Qry_Diet_Day" which has the list of food and portion consumed in a given day
- I have query "Qry_Nutr_Day" which is the same data as "Qry_Diet_Day" but each food is exploded into every single nutrient and the calculation of it per the amount consumed (for example egg appears in 20 rows to calculate each nutrient by the portion of egg consumed, and then bacon appears another 20 times, and orange juice another 20 times, etc...)
what I need is a query that only summarizes the nutrients consumed from the whole "Qry_Nutr_Day" but showing only one row per nutrient (query of 20 rows total) like in"tbl_Nutrients"
how can I do that?
thanks for your time!