Build report on multiple values in a single field

[Demetious]

Hi folks,
I'm trying to build a report based on mulitple data within a field. I have option 1 and option 2 as a combo box within a record field. I have created two reports. One for a list of option 1's checked, One for option 2's checked. If both are checked, then I want them to show up in both reports. Eventually I will add more options to this but this will be my foundation. Thanks for any assistance.

 

[Uncle Gizmo]

I don’t quite understand what you’re trying to do, could you provide more information please.

 

[Demetious]

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.

When I open Product A report, I want to show those records with product a and/or both checked.

When I open Product B report, I want to show those records with b and/or both checked.

We keep an inventory of parts but we use the parts for multiple products. So when I want to pull parts for a particular product, I can open a report and only show the parts for whatever product we are building at the time.

I hope this clears it up a bit. Thanks for any help.

 

[Demetious]

Folks,
I got it done, I asked a useless question, sorry for being a noob.