Re: Results in Parallel columns
Date: Thu, 15 Jun 2006 03:26:19 GMT
If I understand the question, my vote goes to Piet's solution. If you have unmatched rows in either Query, then you'd need something a bit different.
Microsoft Access MVP
"vivekian" <vivekaseeja_at_gmail.com> wrote in message
> Hi ,
> I need to place the results of two different queries in the same result
> table parallel to each other.
> So if the result of the first query is
> 1 12
> 2 34
> 3 45
> and the second query is
> 1 34
> 2 44
> 3 98
> the results should be displayed as
> 1 12 34
> 2 34 44
> 3 45 98
> If a union is done for both the queries , we get the results in rows.
> How can the above be done.
> Thanks in advance,
Received on Thu Jun 15 2006 - 05:26:19 CEST