Left Join Query

[Danu]

This should be simple but I am having a problem. I have a table which I have
set up in a left join query against a much larger table. The common field is
the account number. (In the larger table, there is only one record per
account number.) Ideally, if there are 30 records in Table A, my results
should have 30 records. I am picking up other pieces of information from
Table B. The only stipulation I have is that the order reason field in Table
B <>Z. But, even if a record in Table A does not have a matching record in
Table B, shouldn't the record be displayed in the results?

The data type for the account number field in both tables is set to text.
There are no leading spaces in Table A. The only thing that is different
about Table A is that I have to import it from Excel using the Access Import
Wizard.

Help is appreciated.

 

[KARL DEWEY]

If you use a criteria it will only pull records that match even in a left join.
Soultion is to add to criteria like this --
<>"Z" OR Is Null

 

[Danu]

Thanks, Karl! I didn't know that.

If you use a criteria it will only pull records that match even in a left join.
Soultion is to add to criteria like this --
<>"Z" OR Is Null