Newbie problem: queries with one-to-many relationships

[BillyTehKid]

Hi,
I have two tables for a research study: Participants and Assessments.
The "Participants" table contains descriptive info on my study participants (names, ID etc).
The "Assessments" table contains outcome data collected at different time points for the participants.
Each participant has the same assessment data collected about them at four time points - so a one-participant-to-many-assessments relationship.
I want to run a simple query where I get, for one assessment tool, the data for all four time points matched up with each participant.

In other words, assuming I conduct three types of assessment (Ax1, Ax2, and Ax3) at four time points (Time1, Time2, Time3, and Time4)... I want a query that just shows a single row for each participant, then in each subsequent column shows Ax1 at Time1, Ax1 at Time 2, Ax 1 and Time 3, and Ax 1 at Time 4).

At present my query displays a new line for each unique participant-assessment relationship. So I have a query showing four rows for every participant, with the unique ID for each assessment, and all the Ax1 data in one column.

How can I get Access to do what I want it to do?

Thanks

 

[Pat Hartman]

Use a crosstab query. The wizard will help you build it.

 

[BillyTehKid]

Thanks! That solved my problem. Still lots of fiddling and trial-and-error involved, but its very helpful to know that this was the right track to go down. It's difficult to know where to start when your just learning Access! So, much appreciated.

Billy teh Kid

 

[Pat Hartman]

I forgot to say welcome. We're glad you found us