J
JE
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.
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.