Qry using date criteria, member count and null fields

[khenry]

I have a database with multiple tables. I need to write a query with the following table/fields...

Household Table
HH# (random household ID #)
FirstName
LastName
HHSize (this is a household size)

ProgramActivity Table
Date


ProgramActivity

Based on the above tables and fields, I need to determine what households have a program activity dated between 10/1/08 - 9/30/09 that were not served with program activity dated between 10/1/06 - 9/30/08 AND receive an unduplicated member count.

Many households may have multiple program activities listed in the time period. All I need is one program activity between 10/1/08 - 9/30/09 to compare whether or not they were seen between 10/1/06 - 9/30/08 and count how many people were in the house at that time. The outcome would be, for example, 4,268 unduplicated members were seen between 10/1/08 - 9/30/09 that were not seen in 10/1/06 - 9/30/08.

Is this query possible? Any help given would be greatly appreciated.

Thanks

Karen

[SteveF]

Household Table
HH# (random household ID #)
FirstName
LastName
HHSize (this is a household size)

ProgramActivity Table
Date
ProgramActivity

Are the table columns listed here the only ones in the table? Based on what you've supplied I can't see a way to identify which household(s) have benefited from program activities.

If there are indeed more columns, please supply the complete list for each table.

Steve