<div>
Oh...I did not know of that technique with the inner join in the inner join. &nbsp;Thanks, I will try it in the morning.<br />
<br />
jimbo99999
</div>


Oh...I did not know of that technique with the inner join in the inner join.  Thanks, I will try it in the morning.

jimbo99999

<div>
<div class="content wysiwyg-content">
Good Day Experts<br />
<br />
Perhaps you all can assist me as my MS Access query building experience is rather light. &nbsp;<br />
I have three tables that I am working with...InvoiceHeader, InvoiceDetail and Address.<br />
I am interested in getting all of the data fron the InvoiceDetail table for each InvoiceHeader record. &nbsp;InvoiceNumber is the common field between the two tables. &nbsp;In the InvoiceHeader and Address tables, I have a field names StoreNumber. &nbsp;I want to get the address information from the Address table. &nbsp;<br />
<br />
Conceptually this seems doable:<br />
1)Get InvoiceDetail records based on InvoiceHeader.InvoiceNumbe<wbr />r<br />
2)Get Address records based on InvoiceHeader.StoreNumber<br />
<br />
I do ok when not trying to do the Address table. &nbsp;But, I am not sure how to do it to get the address &nbsp;table data.<br />
<br />
Any helpful hints or insight is appreciated,<br />
jimbo99999
</div>
</div>


Good Day Experts

Perhaps you all can assist me as my MS Access query building experience is rather light.  
I have three tables that I am working with...InvoiceHeader, InvoiceDetail and Address.
I am interested in getting all of the data fron the InvoiceDetail table for each InvoiceHeader record.  InvoiceNumber is the common field between the two tables.  In the InvoiceHeader and Address tables, I have a field names StoreNumber.  I want to get the address information from the Address table.  

Conceptually this seems doable:
1)Get InvoiceDetail records based on InvoiceHeader.InvoiceNumber
2)Get Address records based on InvoiceHeader.StoreNumber

I do ok when not trying to do the Address table.  But, I am not sure how to do it to get the address  table data.

Any helpful hints or insight is appreciated,
jimbo99999

MS Access JOIN Query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.