Make rows of a table become collums of a Query?

[Guest]

I have a table that contains multiple information about meetings between
companies. The table consists of a meeting key, a foriegn key form companies
and a foriegn key that relates to the time slot.

What i would like to do is produce a list of all the times and companies
that a specific company will be linked to. I can produce a query to show all
time slots that a company is in, by creating a query with all the relevent
information and filtering on the company ID. Equaly I can find out all the
companies that are attending a specific meeting by building a similar query
and filtering on time slot.

However i want a list that shows for any given company all the time slots
they are booked into, and who it is that they are meeting with, all on the
one list.

Any assistance at all would be verry verry much appreciated. Further
information is ofcourse available if neccasary

 

[John Ortt]

Do you know about crosstab queries. They effectively turn your rows into
columns as you outlined.

Try using the crosstab query wizard and then analyse the methodology in
design view........

Hope that helps,

John