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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Union query 5
SUM in a UNION query 2
Union query not displaying select statement 1
Adding data to MS Access from csv file 0
DLookup in Continuous form 0
Union Query and Field Alias 7
Keep name of source query in Union 2
Creating a parameter in a Union Query 2

Top