Query satisfing two conditions

[Chum]

I'm using Access 2002

A table contains a last name and first name field. There are an additional 14 fields A, B, C, ..., J indicating jobs assigned using the yes/no data type. Generally an individual is assigned only one job. A check mark is put in that cell. There are a number of individuals that have 2 assigned jobs. Therefore a check mark is in two different cells for that person.

Can a query be created containing the records of those individual that have two jobs?

 

[John Big Booty]

This sounds like a highly de-normalised table structure this tutorial may help you better understand the concept.

The discussion here may also give you some pointers.