My in-file has many records with the same acct# but different book-ids (one acct# can purchase many books)
My boss asked me to create a program where I show a single acct# with multiple book-ids on the same record (to help show buying trends from a single acct#)
sample output
(ACCT#) BOOK-ID1 BOOK-ID2 BOOK-ID3 ETC.... Up to 20 purchases
75643334 ACTION123 ACTION222 SPORT222
75643334 ACTION123 ACTION222 SPORT222
Does anyone have some sample code I can work from as the easytrieve manual doesnt show anything.
thanks for your time,
N.