New here so I might confuse some people with my ask-
So I have a table that looks something like the below (dash to represent different column):
Delivery Date - Food 1 (yes/no) - Food 2 (yes/no) - Food 3 (yes/no) - Value of Food Delivered
There is a reason why I had to create True/False categorization for each of the type of food delivered, rather than a single column with "Food Type".
I have a query that sums the rows together based on delivery date- and the food delivered on that day would show up true in a single row.
Currently this also sums all the value of food delivered on the day.
If I wanted to create another column in the query to sum the value of Food 1 and Food 2, even if Food 3 was also delivered, without having to exclude the fact that food 3 was indeed delivered, could I do this?