Concatenate multiple rows
in [Queries]
|
Prev: open a message box if a query is null during an autoexec macro
Next: split up one field into multiple fields
From: Sherri Dean on 28 Apr 2010 12:53 @Duane Hookom I have a similar problem as above, but this link no longer works. Any current advice? "Duane Hookom" wrote: > There is a generic function with sample usage at > http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane > > -- > Duane Hookom > MS Access MVP > -- > > "Cydney" <Cydney(a)discussions.microsoft.com> wrote in message > news:0F42A9D7-3240-4C1B-8A14-281FAD05860B(a)microsoft.com... > > Is there a good way to concatenate data from multiple rows into one field? > > I > > have several rows with different dates and I need to combine the comment > > text > > for each of the dates into one field and group it all as one record. How > > can > > I do that? > > -- > > THX cs > > >
From: Duane Hookom on 28 Apr 2010 21:35
I believe this issue has been handled off-line :-) -- Duane Hookom MS Access MVP "Sherri Dean" <SherriDean(a)discussions.microsoft.com> wrote in message news:FB0C2C05-B724-4C40-80CB-6352E2D1DB63(a)microsoft.com... > @Duane Hookom > I have a similar problem as above, but this link no longer works. Any > current advice? > > "Duane Hookom" wrote: > >> There is a generic function with sample usage at >> http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane >> >> -- >> Duane Hookom >> MS Access MVP >> -- >> >> "Cydney" <Cydney(a)discussions.microsoft.com> wrote in message >> news:0F42A9D7-3240-4C1B-8A14-281FAD05860B(a)microsoft.com... >> > Is there a good way to concatenate data from multiple rows into one >> > field? >> > I >> > have several rows with different dates and I need to combine the >> > comment >> > text >> > for each of the dates into one field and group it all as one record. >> > How >> > can >> > I do that? >> > -- >> > THX cs >> >> >> |