K
kennethburr
I have a fields in Access 2003 labeled hsize, which holds the number of
people in a household. I have another field named hincome, which holds
the total annual income for that household. I am trying to develop a
calculated field in a query that will match up to a chart I have, which
shows for each size household ( 1 though 8) the median income for that
size of household, and then depending on the actual total household
income for that family size their income level and eligibiity. For
example, a household is considered low income if it has less than 50%
of the median income for that size family, or if 51% to 80% of the
median income for that size family, the income is considered moderate,
or if over 80% then the result is not eligible. I started trying to do
a nested IIF statement, but then I realized that with all the nesting
that would be required for three different possible outcomes for 8
different household family sizes there must be a better way. I would
greatly appreciate any suggestions.
Ken Burr
people in a household. I have another field named hincome, which holds
the total annual income for that household. I am trying to develop a
calculated field in a query that will match up to a chart I have, which
shows for each size household ( 1 though 8) the median income for that
size of household, and then depending on the actual total household
income for that family size their income level and eligibiity. For
example, a household is considered low income if it has less than 50%
of the median income for that size family, or if 51% to 80% of the
median income for that size family, the income is considered moderate,
or if over 80% then the result is not eligible. I started trying to do
a nested IIF statement, but then I realized that with all the nesting
that would be required for three different possible outcomes for 8
different household family sizes there must be a better way. I would
greatly appreciate any suggestions.
Ken Burr