Creating Report From Two Tables

  • Thread starter Thread starter Colin
  • Start date Start date
C

Colin

Hi,

Is it possible to create a report which compiles data
from two tables which aren't related?

I have two tables - 'CashSales' & 'Invoices'

I want to list them all at the end of the month and total
each sepeartely, but have them appear on one page, i.e.
one report.

Is this possible? I tried it but it asks to edit the
system relationships.

Regards

Colin
 
This takes a little advanced technique, but create a report for each of the
tables and add those 2 reports as subreports to your "header" report.

(Somehow I don't think I explained that sufficiently...)

Travis
 
If you're basing them both off the same month, then that
is your common field. Insert "Month" field into both
tables, make a query with a relationship between those
fields and add others fields as necessary. Then, make a
report based off of that query.
 
Back
Top