Query join properties

[Joe D]

I have 2 customer tables in a query joined by customer number. Table A
contains payment information and Table B contains notes. I have the
join properties set to show all the records in Table A and only those
records in Table B that match Table A. If I run the query like this
it works fine and shows all records in Table A even if there is not a
note on Table B. I need to exclude any Closed Notes in Table B. When I
put something in the criteria for a field on Table B I do not get all
the records from Table A anymore. I only get the records from Table A
that have notes, it excludes any records that do not have notes. Is
there a way to get the records from Table A that do not have any notes
attached to them?...thanks

 

[Allen Browne]

Create a query into Table B, that excludes the saved notes.
Save this query.

Create another query using Table A and use the query you just saved as in
input table 2 (in place of Table B.) Set up the outer join the way you did
previously.