table record intervals
Posted: Mon Mar 13, 2006 6:12 am
I have the following scenario
table
amount | letter
1 | a
5 | b
7 | c
I need a query if
amount=1,2,3,4,5 it displays letter a
amount=6,7 it displays letter b
amount=8,9,... it displays letter c
table
amount | letter
1 | a
5 | b
7 | c
I need a query if
amount=1,2,3,4,5 it displays letter a
amount=6,7 it displays letter b
amount=8,9,... it displays letter c