Prev: summary report
Next: Disable Sum of Field in Detail Area
From: Lbrister on 3 Jul 2008 15:08
I am creating a database in 2003 and am trying to see if there is some way to
combine records like there is for fields for when I am exporting the report
to excel. Currently it puts each name record in its own cell and it would be
much easier on me for them to be in one cell.
From: Duane Hookom on 3 Jul 2008 21:50
There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

--
Duane Hookom
Microsoft Access MVP


"Lbrister" wrote:

> I am creating a database in 2003 and am trying to see if there is some way to
> combine records like there is for fields for when I am exporting the report
> to excel. Currently it puts each name record in its own cell and it would be
> much easier on me for them to be in one cell.
From: Lbrister on 12 Jul 2008 16:15
This is exactly what I need but the Concatenate function is undefined in my
version of Access 2003. Is this something I am doing wrong or is this
something that has been removed from later versions of access?

"Duane Hookom" wrote:

> There is a generic concatenate function with sample usage at
> http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.
>
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "Lbrister" wrote:
>
> > I am creating a database in 2003 and am trying to see if there is some way to
> > combine records like there is for fields for when I am exporting the report
> > to excel. Currently it puts each name record in its own cell and it would be
> > much easier on me for them to be in one cell.
From: John Spencer on 12 Jul 2008 19:22
Did you go to the site, download the example, and then copy the Function
from the Sample database into your database?

The concatenate is a custom function written in VBA and is in a module
in the sample database.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


Lbrister wrote:
> This is exactly what I need but the Concatenate function is undefined in my
> version of Access 2003. Is this something I am doing wrong or is this
> something that has been removed from later versions of access?
>
> "Duane Hookom" wrote:
>
>> There is a generic concatenate function with sample usage at
>> http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.
>>
>> --
>> Duane Hookom
>> Microsoft Access MVP
>>
>>
>> "Lbrister" wrote:
>>
>>> I am creating a database in 2003 and am trying to see if there is some way to
>>> combine records like there is for fields for when I am exporting the report
>>> to excel. Currently it puts each name record in its own cell and it would be
>>> much easier on me for them to be in one cell.
 | 
Pages: 1
Prev: summary report
Next: Disable Sum of Field in Detail Area