Post reply

vb sort by row

  • April 13, 2009 at 6:23 pm

    #384351

    Is there a way to sort by row in VB?

    My current output is:

    Fund,Central,Midwest,Northeast,Northwest,Southeast,Southwest

    Fund1,$4,270,980.00,$4,827,610.00,$1,250,620.00,$2,962,870.00,$3,202,460.00,$2,173,960.00

    Fund1,$550,000.00,$465,000.00,$545,000.00,$530,000.00,$0.00,$515,000.00

    Total,$4,820,980.00,$5,292,610.00,$1,795,620.00,$3,492,870.00,$3,202,460.00,$2,688,960.00

    My Desired output is:

    FundMidwestCentralNorthwestSoutheastSouthwestNortheast

    Fund1$4,827,610.00$4,270,980.00$2,962,870.00$3,202,460.00$2,173,960.00$1,250,620.00

    Fund1$465,000.00$550,000.00$530,000.00$0.00$515,000.00$545,000.00

    Total$5,292,610.00$4,820,980.00$3,492,870.00$3,202,460.00$2,688,960.00$1,795,620.00

  • April 13, 2009 at 8:10 pm

    #977004

    I am going to guess the answer is Yes. But with the data you have given, it is difficult if not impossible to assist you. Please read the article in my signature block -- provide the table structure, sample data in the formats discussed in the article and the T-SQL statement now utilized to retrieve what you have shown. With that I am sure someone will be able to help you.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply