Re: Doing Summation on multiple criterias on the same column in a

>> As I have asked several times already, what if they are only interested in lemonade? Why should they bother with a list? <<

If the only concern is about lemonade preferences and consumption,
wouldn't everything in that table deal with lemonade consumption? If
so, why would they bother with a flag? It would be like a Personnel
table with a flag that asks "Are you an employee?" when the answer
would have to be "yes" to get into the table.

Let me recover a bit from my physical exam, x-rays and booster shots
and see if I can get a short article about scales, measurements and
data values versus question/answer and other types of flags.

Re: Doing Summation on multiple criterias on the same column in a single query

> If the only concern is about lemonade preferences and consumption,
> wouldn't everything in that table deal with lemonade consumption?

Celko, you are too much.