|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 17th, 2008, 08:34 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Left Join Query
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. 
|
|
#2
July 17th, 2008, 09:19 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Left Join Query
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 -- KARL DEWEY Build a little - Test a little "Danu" wrote: 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.
|
|
#3
July 18th, 2008, 01:34 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Left Join Query
Thanks, Karl! I didn't know that.
"KARL DEWEY" wrote: 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 -- KARL DEWEY Build a little - Test a little "Danu" wrote: 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
