sori didn't read first the guidelines. i am using Access 2003.
Farmers - text data type
Planting Information - Yes/No data type
Harvesting Information - Yes/No data type
In the query, how can i make a criteria on a yes/no data type?so that the outcome will be the farmers name and only those which has a check mark signifying that they want this kind of brochure.it can not include the other field names which doesn't have...