report from two tables

  • Thread starter Thread starter eb1mom
  • Start date Start date
E

eb1mom

I am trying to create a report based on two tables. One has
delay information one has production information. Report
would be sorted by production date and delay date. There
would be perhaps two or three delay records and then a
production record then a couple more delay records then two
production records. I tried creating a query but, I don't
want fields from tables combined into one record. Any
suggestions on articles to read or examples to look at
would be appreciated.
 
You could try building a subreport based on delay
information and the main report built on production
information.
 
Thank-you for your help
-----Original Message-----
If what you're looking for is to display all records from both tables,
without combining common records; you'll need to create a query
that contains a FULL OUTER join between the 2 tables. Then, build
your report based on that query.

Jet doesn't do outer joins but there are workarounds, I suggest
you look for info about full outer joins in jet or post a question
in the queries group.


----- Les wrote: -----

You could try building a subreport based on delay
information and the main report built on production
information.

.
Click to expand...
 
Back
Top