Deleting a join in Query design view?

[DougW via AccessMonster.com]

Hi -
I'm working in Access for the first time in many years.
I have a number of joins created between various tables in the Relationship
window.
I created a query that uses a number of these tables. The previously defined
joins appear
in the query design window by default. My query does not produce any records
unless I delete
one particular join in the query design window (this behavior of the query
makes sense).

What is the consequence of my deleting this join in the query?
The join still appears in the Relationship window after I have deleted it in
the query.
Am I violating some cardinal rule of Access by doing this?

thanks,
Doug

 

[Jerry Whittle]

Instead of deleting the join line in the query, try double-clicking on it
until a dialog box shows. Select the second option which is a left join. See
what happens. If that doesn't work, try the third option.

 

[DougW via AccessMonster.com]

Hi Jerry, thanks for the response.
I tried as you suggested. The second option and the third option both gave
me
an error "the SQL statement could not be executed because it contains
ambiguous outer joins."
and then suggests creating a separate query.

I will try the 2-query route and see if that gets me what I need.

I'm curious why it let me delete or redefine the join in the query design but
the join still appears unchanged in the relationship window.

thanks for your help,
Doug

Instead of deleting the join line in the query, try double-clicking on it
until a dialog box shows. Select the second option which is a left join. See
what happens. If that doesn't work, try the third option.

Hi -
I'm working in Access for the first time in many years.

[quoted text clipped - 14 lines]

thanks,
Doug