Pivot in Access

I have a table with the following:

EncounterID     DiagnosisCode
1                           482.5
1                            702.6
1                           892.5
1                            412.5
2                            825.3
2                            632.4
2                               132.4

I need this:

EncounterID    DiagIDOne     DiagIDTwo   DiagIDThree   DiagIDFour
1                         482.5               702.6                   892.5              412.5
2                          825.3                632.4                 132.4


Any ideas?  

Thank you all in advanced.

JamesNT
JamesNTAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.