Page 1 of 1

table record intervals

Posted: Mon Mar 13, 2006 6:12 am
by pedroz
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

Posted: Mon Mar 13, 2006 9:07 am
by a94060
try writing the code,if it does not work,post it up here and people will check it out. We cant write the whole thing out for you.