using multiple queries on a report

  • Thread starter Thread starter Duc Tran
  • Start date Start date
D

Duc Tran

I would like to use mulitiple queries on one report. Each
query consist of only one column. How do I go on about
doing this? Please help. Please email me at
(e-mail address removed)
 
Duc said:
I would like to use mulitiple queries on one report. Each
query consist of only one column. How do I go on about
doing this?
Click to expand...


Private consulting is a separate business from newsgroups,
no private emails from most people. Or, as Larry would say,
You ask it here, we answer it here.

Now, to your question. How is the data in these queries
supposed to be merged together? There are several ways that
you're question can be interpreted so it's not at all clear
what you're trying to do.

Here's one way that just appends the data all in the one
column:

SELECT thefield FROM query1
UNION ALL
SELECT thefield FROM query2
UNION ALL
. . .
SELECT thefield FROM queryN

If you want the data in separate columns, then you have to
have a way (primary key and foreign key) to relate the
records together so the fields in each result record go
together properly.
 
Back
Top