sly like Coyote
Registered User.
- Local time
- Today, 11:05
- Joined
- Apr 14, 2010
- Messages
- 82
I'm trying to write a select query and I'm having some trouble. I have one table, tbl_Households, that holds information about a family and another, tbl_Individuals, that holds information about the actual people in that family (name, age, etc) along with a foreign key identifying which household they're part of.
What I want to do is have two queries, one which returns all the individuals that are associated with households that contain no children, and one which returns all individuals that are in households that contain both children and adults.
I had (foolishly) thought that I could just use the access query tool and make it work by including more than one instance of the field I needed to test, but after thinking about it that obviously won't work. Can anyone lead me in the right direction here?
What I want to do is have two queries, one which returns all the individuals that are associated with households that contain no children, and one which returns all individuals that are in households that contain both children and adults.
I had (foolishly) thought that I could just use the access query tool and make it work by including more than one instance of the field I needed to test, but after thinking about it that obviously won't work. Can anyone lead me in the right direction here?