B
Bryan Hughes
Hello,
I have a table:
Table (Income_Guidelines)
Field2 [Level]; Field3 [Family_Size]; Field4 [Income]
1 1
$10,550
1 2
$12,050
1 3
$13,550
2 1
$17,550
2 2
$20,100
2 3
$22,600
3 1
$28,100
3 2
$32,150
3 3
$36,150
4 1
$28,101
4 2
$32,151
4 3
$36,151
How should I write the strSQL, to return the [Level]?
strSQL = "SELECT [Level] FROM Income_Guidelines "
strSQL = strSQL & "WHERE [Family_Size] =" & intFMS & " AND "
strSQL = strSQL & "Income ?
curIncome will be variable.
I need the level if user inputs intFMS=3 And curIncome = $27,000
How can I get the Query to return Level= 2?
TFTH
-Bryan
I have a table:
Table (Income_Guidelines)
Field2 [Level]; Field3 [Family_Size]; Field4 [Income]
1 1
$10,550
1 2
$12,050
1 3
$13,550
2 1
$17,550
2 2
$20,100
2 3
$22,600
3 1
$28,100
3 2
$32,150
3 3
$36,150
4 1
$28,101
4 2
$32,151
4 3
$36,151
How should I write the strSQL, to return the [Level]?
strSQL = "SELECT [Level] FROM Income_Guidelines "
strSQL = strSQL & "WHERE [Family_Size] =" & intFMS & " AND "
strSQL = strSQL & "Income ?
curIncome will be variable.
I need the level if user inputs intFMS=3 And curIncome = $27,000
How can I get the Query to return Level= 2?
TFTH
-Bryan