Separating Data from Query into Two Columns?

[Emmy]

Thanks very much for your help.

I have a table called People. When I click on the "+" in far left hand column in "People", it expands to another mini table "Information" that contains data about each record in People (i.e. age, telephone number, etc). Please note that there are only two columns in the "Information" table:
- Data
- Information Type (i.e. Age, telephone number)

I would like to write a query that displays the data in 3 columns:
- Person's Name (from People Table),
- Age (from "Information" table)
- Telephone Number (from "Information" table)

However, my query always displays the data in 2 columns, it lumps both Age and Telephone in the same column. Is there a way I can tell my query to separate the data from the information table depending on what type it is (i.e. have age and telephone number in separate columns?)

Thanks very much in advance.

[This message has been edited by Emmy (edited 01-05-2002).]

 

[Jack Cowley]

Add the People and the Information table to a query. Join them on the common field if they are not already joined. Drag Name from the People table to a column in the grid. Do the same for Age and Telephone Number from the Information table (each to a separate column). Now your query will show Name, Age and Telephone Number in separate fields.