Posted by: Nepalover September 25, 2006
Login in to Rate this Post:
0
?
Batuwa,
I used the following query and it worked:
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;
But I also need to have the last column (total column) that should add Appleslice, OrangeSlice, BananaSlice and give the total numbers of all fruits. How do I add the statement to add the running total of those fruit slices and add them all together?
I appreciate your help and
Happy Bijaya Dashami!