join queries for report recordsource

  • Thread starter Thread starter judy
  • Start date Start date
J

judy

I have fields from 1 table and 6 queries that I need to
somehow all get onto a report--2 of the queries are sum
totals, and the other 4 are criteria queries on the same
field-- noting when rent is past due 30,60,90 or over 90
days.

I'm trying to create 1 query that has all the fields I
need to use as a record source for the report, and I
understand that can be done with a Joint query--but how?

the table is ClientInfo: I need to list Last Name, Unit
Number, Phone Number from there. Then each query really
only has 1 field, and I need each of those.

Help?
 
Here is a trick you can use:
What is 1 times any number?
(The number).

If you put two tables (or queries) in an Access query window and you do NOT
join them you will get an answer that is the number of rows in one table
times the number of rows in the other table. (This is called a Cartesian
product.)

But go back to my trick!

You can put all of the single row queries you want into a single query
window and NOT join them.
You will still get only 1 row as the result!
(And it will have all the fields!)
 
Back
Top