Hello,
Our tables store our notes in sequential observations parsed 50 characters per row such that the note gets broken into n records with the same date_time and time and are labeled sequentially. What I'd like to do is query to put these back together. I am aware of doing a crosstab query and then concatenating them, but these notes can exceed the number of columns a cross tab query is limited to. Does anyone know how to do this? I've done this before in SAS by creating a new column and then starting at the bottom sequence of each grouped (survey,ID,date_time) and concatenating the text line above to the one below. This may require VBA but I don't know VBA. Anyway,
Please post sample code if you can, I'm still learning.
Survey ID date_time Seq time_key Textx
123 1 datetime1 1 time1 Hello
123 1 datetime1 2 time1 World
123 1 datetime2 1 time2 Good
123 1 datetime2 2 time2 Bye
Desired Result:
Survey ID date_time Seq time_key Textx
123 1 datetime1 whatever time1 Hello World
123 1 datetime2 whatever time2 Good Bye
Please Help!