Ambiguous outer joins

[Connie]

I keep getting a message stating "The SQL statement could
not be executed because it contains ambiguous outer joins.
To force one of the joins...." My problem is 1)I can't get
into the area to fix this 2)I am in a database that was
created by another employee who is no longer here so I
don't know what they did.
Is there a way I can find the information so I can fix the
problem?

 

[Les]

What are you running when you get the message? Is it a
report or a query? If you are in the database that
someone else wrote, you can probably get into the area to
fix the problem.

If you are running a report, open the report in design
view. Look at the properties to find the record source.
It will probably be a query that the report is based on.
Then, find this query. Open it in design view, and you
should see how the tables are joined.

If you are running a query, open the query in design
view. You should see how the tables are joined.

Hope this helps.

 

[Connie]

That worked. Thanks!

-----Original Message-----
What are you running when you get the message? Is it a
report or a query? If you are in the database that
someone else wrote, you can probably get into the area to
fix the problem.

If you are running a report, open the report in design
view. Look at the properties to find the record source.
It will probably be a query that the report is based on.
Then, find this query. Open it in design view, and you
should see how the tables are joined.

If you are running a query, open the query in design
view. You should see how the tables are joined.

Hope this helps.
.