You know something, I should have read the initial post better. Asking a question is why we have the forums but the initial question wanted a miracle. Fix my problem...

Not every one knows everything. No need to be rude, ask for what you need to answer the question or ignore the question. I am getting tired of rude...

I thank both of you, as a new user of SQL I new what I wanted, just didn't know the terminology to find it.

With apologies and thanks in advance, I am using SQL2005

Here is the query

Select Acct_num AS 'GL Number', Acct_desc AS Item,

Acct_short_desc Description, BALANCE--What we want displayed

From Chart_Of_Accounts--Name of the...