We have a database of our customers who need financial assistance. One of our programs provides assistance to people whose total household income is 125% of poverty based on the HHS Poverty Guidlines. The database has a customer information form. I’ve been asked to add a field to the form that identifies those households who meet the 125% over poverty criteria. At this point, they haven’t asked me for anything other than to be able to run our regular customer report and include a field showing whether or not they meet the poverty assistance criteria. They want to see the field in the data entry form we already have as well as in the report. And, they said a simple YES or NO would suffice. They don’t need to see the calculation.
I have a query that has the total number of people in the household and the total household income.
The HHS Guidelines are:
1 person – income of $10,400
2 people – income of $14,000
3 people – income of $17,600
4 people – income of $21,200
5 people – income of $24,800
6 people – income of $28,400
7 people – income of $32,000
8 people – income of $35,600
each additional person over 8, add $3,600 to the 35,600
So, how do I do this? I was originally thinking of an IF statement to determine if the houshold income and number of people qualifies them as having income over 125% of poverty. But, I can’t find an IF statement in Access, and even if I could, I wound myself into circles trying to figure out how to build it. Thank you for helping me. I’ve been struggling with this for a couple of days now.
I would greatly appreciate your help!
