Expression to enter data from one column 2 multiple columns in a q

[Rose]

I am working with data in a table that includes records for multiple years
per ID. I want to create a query that creates a separate column of
information for each year so I can see data for each ID over multiple years
and I'm not sure how to write an expression that wont filter out subssequent
information.

Here’s how the data is in a table:
ID Period Result

1 2007 Effective

1 2006 Effective

1 2005 Ineffective


Here’s how I want it on the query:

Control 2007 Result 2006 Result 2005 Result

1 Effective Effective Ineffective


Thanks!

 

[KARL DEWEY]

Use a crosstab query.
If you need help with it post back.

 

[Rose]

Karl,

My issue is a bit more complicated as I'm dealing with about a dozen tables
and need 7 other headings as I am using the query as source data for a report
that has parameters selected by the user through a form. I've tried IIF,
SELECT and a few other things. I guess I could create 2 additional queries
and add them to the master query but I'm hoping there's an easier way.

Any other ideas? Rose.

 

[KARL DEWEY]

I'm dealing with about a dozen tables and need 7 other headings
Post your table structures and sample data.