queries on report

  • Thread starter Thread starter Suze
  • Start date Start date
S

Suze

I have 2 queries and I want to show both on 1 report. I get an error message
that says:
"You have chosen fields from record sources which the wizard cannot connect.
You may have chosen fields from a table and from a query based on that
table. If so, try choosing fields from only the table or query"
What the heck does that mean and how do I get around it?
 
Suze,

You need to be a little more specific on what you're trying to do. Why two
queries? What kind of info does each retrieve?

Nikos
 
In order to create a single report from multiple queries you will need a way
of joining the two together. If they are not joined you will probably get
the equivilent of a cross-join, which basically creates every possible
combination from both sources (i.e. lots of records).

If the query fields are the same, create a third Union query which will give
a single query output from multiple query inputs.

Can you explain what you are trying to do in a little more detail?
 
One table, mutiple queries. Simply put, I have a query that says "give me
all records that meet this criteria." Another query that says "give me all
records that meet this other criteria." Another query, etc. They all just
pull different records from the same table. I'm an Access novice so I don't
know how to write my queries with the Union thing mentioned below. A lot of
the Access help files go over my head.
 
Can you just combine all the different criteria into a
single query with ORs ?

For example, if you say "give me all records which are
apples" in one, and then say "give me all the records
which are oranges" in another, can you say "give me all
the records which are apples OR oranges" ?
 
Back
Top