Merging text data from sequential records

  • Thread starter Thread starter Fons Ponsioen
  • Start date Start date
F

Fons Ponsioen

Can someone help me, I need to merge text strings from
records with the same data. How do I go about this.
Fons
 
Could you take the time to type a few records as well as the desired output
into a reply? I am having trouble understanding what you have and what you
want to accomplish.
 
I have a table with a date and a text data field.
What I am trying to do is combine the text strings for
entries with the same date into a single text string.
Like:
1/2/2004 trip A start
1/2/2004 trip B end

resultant query should have
1/2/2004 travel start , travel completed

the reason for combining the text into one string is so I
can use it in a calendar type crosstab query like
day month Jan Feb etc:
1
2 trip A Start, trip B end
etc.
 
Back
Top