I am not sure if this objective may be easily achieved but,

I have query that returns the following results:

ID# Initials Individual Name State
111111 AAA Smith,Joe AK
111111 AAA Smith,Joe AL
111111 AAA Smith,Joe AR
111111 AAA Smith,Joe AZ
111111 AAA Smith,Joe CA
222222 BBB Jones,Jane AL
222222 BBB Jones,Jane AZ
222222 BBB Jones,Jane MO

I would like the results to be displayed as:

ID# Initials Individual Name State
111111 AAA Smith,Joe AK AL AR AZ CA
222222 BBB Jones,Jane AL AZ MO

Each person could have different combinations of States

I researched Concatenate but because the State is in the same field, I do
not beleive it is the correct command.

Is there a simple way to achieve this?

Many thanks.

Take a look at the code on the following web site:

http://www.mvps.org/access/modules/mdl0008.htm

This code will allow you to do what you want.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.



"JE" wrote:

> I am not sure if this objective may be easily achieved but,
>
> I have query that returns the following results:
>
> ID# Initials Individual Name State
> 111111 AAA Smith,Joe AK
> 111111 AAA Smith,Joe AL
> 111111 AAA Smith,Joe AR
> 111111 AAA Smith,Joe AZ
> 111111 AAA Smith,Joe CA
> 222222 BBB Jones,Jane AL
> 222222 BBB Jones,Jane AZ
> 222222 BBB Jones,Jane MO
>
> I would like the results to be displayed as:
>
> ID# Initials Individual Name State
> 111111 AAA Smith,Joe AK AL AR AZ CA
> 222222 BBB Jones,Jane AL AZ MO
>
> Each person could have different combinations of States
>
> I researched Concatenate but because the State is in the same field, I do
> not beleive it is the correct command.
>
> Is there a simple way to achieve this?
>
> Many thanks.