I have included a link at the end of this thread to download and open my test database.
I have currently structured it with One field that has an Item ID name (for every item i currently sell). And the rest of the fields are just customer names. I have a check box for each item code that corresponds to each customer name. and if there is a check in the box that means the customer owns the item already.
I was wondering how i would build a query where it shows one specific Item ex: wbc101, and which customers have a check in the box for that item code.
In other words, Say i want to see only people who HAVE the item wbc101, and exclude customers that don't have it (not checked). How would I get that to happen with a query?
Sorry if its unclear. but once you see the Database I have structured i hope it makes sense.
Thanks!
DB: http://www.4shared.com/file/Y6hHMfds/Test1.html
(Sorry I couldn't make it an attachment. There is a 500kb limit )