[MS_AccessPros] Finding Poverty Levels

 

I have to get a count of households that fall in the each poverty level and I am not sure of the logic:

Here is the tblPovertyGuidelines:

PersonInHousehold PovertyGuideline
1 $11,170.00
2 $15,130.00
3 $19,090.00
4 $23,050.00
5 $27,010.00
6 $30,970.00
7 $34,930.00
8 $38,890.00

I know I have to get a count of people in each household:

SELECT Count(tblApplicationHousehold.HouseholdID) AS CountOfHouseholdID, tblApplicationHousehold.ApplicationID
FROM tblApplication INNER JOIN tblApplicationHousehold ON tblApplication.ApplicationID = tblApplicationHousehold.ApplicationID
GROUP BY tblApplication.AppActiveFlag, tblApplicationHousehold.ApplicationID
HAVING (((tblApplication.AppActiveFlag)=Yes));

Then I need to lookup each household member that has income and produce the annual amount (they report monthly amounts):

SELECT tblApplicationHousehold.ApplicationID, [FirstName] & " " & [LastName] AS [Member Name], tblApplicationHousehold.RelationshipID, tblApplicationHouseholdIncome.IncomeTypeID, tblApplicationHouseholdIncome.IncomeAmount, [IncomeAmount]*12 AS [Annual AMount]
FROM tblApplicationHousehold INNER JOIN tblApplicationHouseholdIncome ON tblApplicationHousehold.HouseholdID = tblApplicationHouseholdIncome.HouseholdID;

THis is where I get lost. Now I need to put it all together, please help!

Thank you
Art Lorenzini
Sioux Falls, SD

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 7
• New Files 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___