If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Merging text data from sequential records
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 |
#3
|
|||
|
|||
Merging text data from sequential records
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 . |
#4
|
|||
|
|||
Merging text data from sequential records
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 . |
#5
|
|||
|
|||
Merging text data from sequential records
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 . . |
Thread Tools | |
Display Modes | |
|
|