I have a simple table with the following fields; jobid, country,
state, and county, i use this for a report that looks like this

Country, State, County
USA PA Washington
Allegheny
Westmoreland

I would like it to look like this
Country State County
USA PA Washington, Allegheny, Westmoreland
NY Bronx, Manhattan, Brooklyn

etc.

Any ideas would be a great help.

On Thu, 10 Feb 2011 09:54:54 -0800 (PST), vvariety <(E-Mail Removed)>
wrote:

>I have a simple table with the following fields; jobid, country,
>state, and county, i use this for a report that looks like this
>
>Country, State, County
> USA PA Washington
> Allegheny
> Westmoreland
>
>I would like it to look like this
> Country State County
> USA PA Washington, Allegheny, Westmoreland
> NY Bronx, Manhattan, Brooklyn
>
>etc.
>
>Any ideas would be a great help.

A Crosstab can't easily do this, but you can get this concatenation with the
help of a little bit of VBA code:

http://www.mvps.org/access/modules/mdl0004.htm
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com