Outer join

  • Thread starter Thread starter Jacques
  • Start date Start date
J

Jacques

How can I get two outer joins to produce results.

I made a cartesian query to force all records from one source to show, but I
have two sources that need to be forced.
When I try it, the ambiguos join error hits me and recommends that I make a
second query and make the second outer join there, but that never produces
all the records.

Making the first join causes some fields to be blank in some of the records
(which is the desired result) but the second query using the next join won't
produce those blank records because the blank field is what the second join
is using and blank doesn't match anything in the other field.
 
You should give us a sample of what you are trying to achieve.

From now, I can tell you that you probably need something like a Full Outer
Join or a Union on two Outer Joins. However, I don't remember if Access has
support for the Full Outer Join; which left you with the Union.

Also, please explain what you really mean by a cartesian query. In my book,
a cartesian query is a query without any join; which returns the cartesian
product of the two tables.

S. L.
 
I'm trying to produce a report that is four pages (based on four
OfficeBranches).
I have two queries TotalHrs and TotalHrsForTheMonth
Columns include OfficeBranch, JobTitle, Hrs, (and TotalHrsForTheMonth has a
fourth column called PayrollDate to filter by the month).

I have to show all four OfficeBranches whether they are in the records or
not (four pages - four office branches), and show all the JobTitles in the
TotalHrs query even when they don't show for the TotalHrsForTheMonth.

All four pages will have JobTitles TotalHrsForTheMonth TotalHrs (and
the report will have text boxes that show corresponding percentages).
 
Back
Top