I have a table named [Inventory].
A record contains [Mfr Part #], [Location], and [Product]
[Product] has two fields at the moment, a multiple choice of two values say "a" and "b". The combinations of those values can be none, a, b, or both.
I have named my reports product a and product b...