Merging text data from sequential records

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.

--
Duane Hookom
MS Access MVP
--

"Fons Ponsioen" wrote in message
...
Can someone help me, I need to merge text strings from
records with the same data. How do I go about this.
Fons

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.
-----Original Message-----
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.

--
Duane Hookom
MS Access MVP
--

"Fons Ponsioen"
wrote in message
...
Can someone help me, I need to merge text strings from
records with the same data. How do I go about this.
Fons


.

You can use the generic concatenate function as the Value in the crosstab.
The function and demo is at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane

Or, you could build your calendar report using the demos at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4

--
Duane Hookom
MS Access MVP
--

"Fons Ponsioen" wrote in message
...
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.
-----Original Message-----
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.

--
Duane Hookom
MS Access MVP
--

"Fons Ponsioen"
wrote in message
...
Can someone help me, I need to merge text strings from
records with the same data. How do I go about this.
Fons


.

Thanks, I had missed that in an earlier posting.
Tha works great.
Fons
-----Original Message-----
You can use the generic concatenate function as the Value
in the crosstab.
The function and demo is at
http://www.rogersaccesslibrary.com/O...aries.asp#Hook
om,Duane

Or, you could build your calendar report using the demos
at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4

--
Duane Hookom
MS Access MVP
--

"Fons Ponsioen"
wrote in message
...
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.
-----Original Message-----
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.

--
Duane Hookom
MS Access MVP
--

"Fons Ponsioen"
wrote in message
...
Can someone help me, I need to merge text strings
from
records with the same data. How do I go about this.
Fons


.



.