Posted by: batuwa September 15, 2006
Login in to Rate this Post:
0
?
Ok, I was not understanding your query...
here is what you need to do..
SELECT Fruit, Num, IIf([Fruit]='Apple',Num*3) AS AppleSlice, IIf([Fruit]='Orange',Num/2) AS OrangeSlice, IIf([Fruit]='Banana',Num+3) AS BananaSlice
FROM Table1;
Good luck!