Mark --

As Nadya suggests, the crosstab wizard looks like it will fill the bill.

Jay

>thanks Jay,
>
>well this is the stru of the table
>
>results table (many records up to 30 per Id)
>id_fk, qty0, result0
>
>
>the main parent table (one record per page)
>id
>pageid
>
>now the parent is on a one to many with the results, being the key
>the ID no
>
>I have Id = 1 on the main parent table and probably about 30 entries on the
>result table, how do I go by displaying those 30 Qty,results horizontaly
>
>
>
>
>
>
>>Maybe?
>>
>>If you could be more specific with the columns/join of the 2 related tables, and what columns you want to extract from them for display, and your desired format, that would help us give a more specific response.
>>
>>Jay
>>
>>>Hello guys,
>>>
>>>Is there a way to query a table where I have 30 columns,
>>>not all of the columns have info, this table is a one to many
>>>relationship with another one (being that other one the one).
>>>
>>>This table have many results of the same parent record in different
>>>columns up to 30
>>>is there a SQL way to show this results horizontaly ?
>>>
>>>or do i have to write a program to report them that way ?
>>>
>>>tx
>>>
>>>mark oliva