Hi all
I have got a db in Access. There are several catagory of material vendors can supply. A vendor can supply more than one category of material. The category of material supplied by a vendor is stored in a field called supplytype with comma seperation. How can I filter and show a report if the query is based on category. Foe example:

Suppose
Company1 is supplying categoryA and categoryB
Company2 is supplying categoryA and categoryC
Company3 is supplying categoryB and categoryC

Now if I want to show in a report who are the vendors sypplying categoryA then what will be the code. Can anybody help me?


Thanking you all