Report on 2 tables with no common field

  • Thread starter Thread starter JGreco
  • Start date Start date
J

JGreco

I cannot figure out how to write a report using two tables
or queries that have NO FIELDS in common - every time I
try it says they have to be joined by a common field. A co-
worker wants info from these two unrelated tables to print
on one report... pretty much just a listing of codes and
descriptions out of the two separate tables. I am using
read-only tables from a different database.
Thank you...
Jan
 
We'd need more details, but if they are not related, how will you combine
the data on the report?

If you want two totally separte listings on one report (one following the
other) then I think you'd just create two separate reports and place them
(as subreports) on a third report.

+------------------------------+
| Main report |
| +------------------+ |
| | Sub 1 | |
| +------------------+ |
| +------------------+ |
| | Sub 2 | |
| +------------------+ |
+------------------------------+

Hope that helps.

Rick B




I cannot figure out how to write a report using two tables
or queries that have NO FIELDS in common - every time I
try it says they have to be joined by a common field. A co-
worker wants info from these two unrelated tables to print
on one report... pretty much just a listing of codes and
descriptions out of the two separate tables. I am using
read-only tables from a different database.
Thank you...
Jan
 
Hmmm... subreports. I've never done that before...

After playing with it for a while, I got the information
to show up correctly now, but am trying to get three
columns for each report on the page. Can't seem to get
that to work right yet, but will continue playing with it.
Thanks very much. :)
 
Back
Top