Report based on two tables (first posted in reports)

[eb1mom]

I am trying to create a report based on two tables. I want
all records from both 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. Relationship between tables is
made using autonumber field from both tables. Any
suggestions on articles to read or examples to look at
would be appreciated.

I was told I may need a full outer join query to get the
report.

 

[John Vinson]

I am trying to create a report based on two tables. I want
all records from both 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. Relationship between tables is
made using autonumber field from both tables. Any
suggestions on articles to read or examples to look at
would be appreciated.

I was told I may need a full outer join query to get the
report.

How do you determine which records interleave with which, and in what
order?

A UNION query might be the solution, assuming that the two tables have
the same number of fields of compatible datatypes.

 

[eb1mom]

Thanks I will try Union query and see how far I get.