Union Query - Bringing 2 records

M

mandy

Hi,

I am trying to do a union query which displays the data I
want correctly. However, it gives me 2 rows of data and I
would like this showing as 1 row.

Any help would be greatly appreciated.

Thanks,

Mans

If you need more information, please let me know.
 
D

Dale Fye

Mandy,

Union queries are designed to merge the rows from to data sources into
a single table, not combine the records from two tables into a single
row.

Can you explain a little more about what you are trying to do, not how
you are trying to do it?

--
HTH

Dale Fye


Hi,

I am trying to do a union query which displays the data I
want correctly. However, it gives me 2 rows of data and I
would like this showing as 1 row.

Any help would be greatly appreciated.

Thanks,

Mans

If you need more information, please let me know.
 
Top