Displaying Query results in a Single Row

[rocky09]

Hi All,

I have a Query, which is running on 2 tables and when I run the query I am getting the results like this.

Name----------Position
Rock----------1
Rock----------2

I want the Results like
Name----------Position----------Position
Rock----------1 ---------- 2

Is there any way to do this.

Thank you in advance,

Best Regards,
Rocky

 

[vbaInet]

Look into a Crosstab Query.