I need help displaying data in a different format.

Data in table:
ID test result = column headers
001 A W
001 B X
002 A Y
002 B Z

Need to display in the following format with only 1 row per ID.
ID A B = column headers
001 W X
002 Y Z

What is the best way to do this?
Thank you!!!

Try a crosstab query.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"I need help!" <(E-Mail Removed)> wrote in message
news:B42DECD3-62AB-4909-8CCC-(E-Mail Removed)...
>I need help displaying data in a different format.
>
> Data in table:
> ID test result = column headers
> 001 A W
> 001 B X
> 002 A Y
> 002 B Z
>
> Need to display in the following format with only 1 row per ID.
> ID A B = column headers
> 001 W X
> 002 Y Z
>
> What is the best way to do this?
> Thank you!!!

Thank you so much! Cross-tab worked like a charm on the 2nd attempt (when I
first tried, I couldn't figure out how to get the values - if I selected an
aggregate function in the wizard, it was not letting me change it to display
the actual values). Thanks again!!!

"Douglas J. Steele" wrote:

> Try a crosstab query.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "I need help!" <(E-Mail Removed)> wrote in message
> news:B42DECD3-62AB-4909-8CCC-(E-Mail Removed)...
> >I need help displaying data in a different format.
> >
> > Data in table:
> > ID test result = column headers
> > 001 A W
> > 001 B X
> > 002 A Y
> > 002 B Z
> >
> > Need to display in the following format with only 1 row per ID.
> > ID A B = column headers
> > 001 W X
> > 002 Y Z
> >
> > What is the best way to do this?
> > Thank you!!!
>
>
>