conditional programming

[crazykatie12346]

Hi,

I'm a complete novice when it comes to VBA. I know absolutely nothing.

I'm creating a database of clients for a nonprofit org. I want to use VBA to determine whether or not a client falls under the poverty line. Income and family size determine whether or not a client is in poverty.

So just as an example:

Family Size Poverty Line
1 10,400
2 14,000

Someone suggested that I put the poverty line values into a separate table and then link the client and poverty table together. So, how do I put those values into a table and then link with client table? Sorry I really know nothing.


Thanks a lot for reading!

 

[Call_Me_Sam]

Hi,

I'm a complete novice when it comes to VBA. I know absolutely nothing.

I'm creating a database of clients for a nonprofit org. I want to use VBA to determine whether or not a client falls under the poverty line. Income and family size determine whether or not a client is in poverty.

Hi, i guess if the family size and poverty values are in a seperate table then you link via the family size. You could query on the income against poverty line and use an iif statement to see if the income fails beneath it.

Hope that helps..