Consolodatin

I am receiving a data dump that has one record for every transaction made in an accounting system. I am trying to take LIKE Doc numbers and consolodating the informatoin into one line. See example below:


Original Dump structure (the slashes are just to format it on this post.):

Doc#-----SX-----VT-----TY-----CODE
100--------1------3------4-------810
200--------1------6------5-------710
100--------6------4------2-------710
200--------2------7------5-------810

I want it to look like this:

Doc#--SX1--SX2--VT1--VT2--TY1--TY2--CODE1--CODE2
100-----1----6-----3----4-----4-----2----810-----710
200-----1----2-----6----7-----5-----5----710-----810

Is this possible and what is the code for it? If somebody can suggest something, it would be greatly appreciated.

Thank you.

I don't think it's a good idea to have it all in one row... Database normalization helps keep your data clean and less-redundant. Your requirements might include displaying all the data on one screen, but that doesn't necessarily mean the database needs to be kept that way. That's the beauty of relational databases.

If I shouldn't consolodate the table, how do you suggest I get all of the Doc specific information into one form? I absolutely need the data of each Doc# to go to one form in one individual record so that I can do a basic accounting scorecard on the data. Any suggestions?

V/r

Beau

What's a form? are you talking about Access? Web page? C++ screen?

I'm sure there are ways in any programming language to pull in data from a variety of places and present them in ways that suit your needs... this is different for all programming platforms though and I'm afraid I might not be able to offer specific advise

Access. I am looking for that language. Thanks for your help anyway.