Create Report with Unrelated data

[AJ]

I am new to access and have two tables that I would like to put on a report.
These tables are completely unrelated (no relationship). Is this possible or
can you only add data to a report from one table or related tables?

THanks.
Completely Confused

 

[Allen Browne]

One approach would be to use a main report bound to Table1, and a subreport
bound to Table2. This would give you the Table1 records, followed by the
Table2 records.

If you actually want to merge the 2 sets of records, presumably the fields
are the same, so you could use a UNION query as the source for the report.
Access can't show UNION queries graphically, but essentially what you do is
to create the 2 queries that give identical fields (same number of fields,
same data type, in the same order), switch the queries to SQL View. Replace
the semicolon at the end of the first query with:
UNION ALL
and then paste in the 2nd query statement.

If you do have 2 tables with identical fields, it might be worth considering
whether you could combine them into one table, with an extra field to
distinguish which type of record it is (like which table it came from.)

 

[Joseph]

Use the wizard to add one of the tables as a subreport in a report that does
not have a record source and select "None" part of the linking section
(Parent to Child Linking). Then do the same with the other. I do this often
when I have several small reports with dissimiliar information or that do not
need to be linked together but need to be viewed at the same time and to save
paper.