Ok i found it!

Thank you very much for the reply.

Erik....

I got it. Under Server Roles i had to add my role..

I am not on a network; i just for some reason can not seem to get loged into this sql2000.

Not sure what to look for..??

I did end up finding the table.. sometimes i have to refresh the database a couple of times..

I did however have to name the columns because the column name...

Thanks..

Just copyed and pasted into a word doc. then pasted into analyer.. works great..

 really nifty looking.  I will spend some time with it,, to try to learn more about the...

Server: Msg 170, Level 15, State 1, Line 11

Line 11: Incorrect syntax near '@tblGROUP'.

i see your guy on the left banging his head... thats what mine feels like..

thank you very much! for the code!

erik...

I know how to do it in vb.net but was wondering if a querry might save some time.. When i ran across the Grouping  with rollup... that is what opened...

Like with the roll up function is it alos posiable to add a row directly after the rollup super summery(bol word )

so:

   $54,455.00

 ============

Thanks for the help!

funny how the ---> '====' + convert(varchar(25),  can be added without being incapsulated in the convert. throwing me for a loop on that one..

That one is a little over my head.. I will need a little brighter picture please//

\

My qustion was more about the fact IS WHEN IMPLEMETING DATA USING THE CHAR(8).. THIS DOES MEAN THAT ONLY 8 CHARTER ARE ALLOWED?

I AM ASKING BECAUSE I WOULD LIKE TO...

Thanks! that works great..

now is there a way to add the '=====' before or after the Total Amout in the Total Amount column?

So in other words it is a fixed length..

correct?