SELECT case, STR(SUM(VAL(v3))) AS v3, STR(SUM(VAL(v4))) AS v4; FROM mytable GROUP BY case ; ...You can use < pre > and < /pre > tags (w/o spaeces) to preserve formatting.
>case v3 v4 >a 105 >a 105 >b 225 >b 225 > >excel(this would be the format I want to get): > >case v3 v4 >a 105 105 > >b 225 225 > > >But this is what I get in excel instead: > >case v3 v4 >a 105 >a 105 >b 225 >b 225>Anyone have any ideas? I have played around with the Select command and have not been successful.