<div>
i'm afraid I got caught up with two other projects and wasn't able to work on this one at all so i'll close for now until I get back to this one..<br />
<br />
thanks for the input, though!
</div>


i'm afraid I got caught up with two other projects and wasn't able to work on this one at all so i'll close for now until I get back to this one..

thanks for the input, though!

<div>
<div class="content wysiwyg-content">
I have two tables that I need to left join but the records need to be manipulated first and I can't quite get it to work...<br />
<br />
the following illustrates what I have better than I can explain it:<br />
<br />
table1.custname &nbsp; &nbsp;left joined to &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; table2.name<br />
john smith &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; smith, john<br />
Alpha Beta &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; bETa, AlPhA<br />
<br />
because my query is a grouping query (or simply because i'm screwing it up somehow), I can't simply do the join in the criteria of the design view.<br />
<br />
if someone can provide the sql on how to join them i'd appreciate it!<br />
<br />
thanks for your help!
</div>
</div>


I have two tables that I need to left join but the records need to be manipulated first and I can't quite get it to work...

the following illustrates what I have better than I can explain it:

table1.custname    left joined to             table2.name
john smith                                                 smith, john
Alpha Beta                                                 bETa, AlPhA

because my query is a grouping query (or simply because i'm screwing it up somehow), I can't simply do the join in the criteria of the design view.

if someone can provide the sql on how to join them i'd appreciate it!

thanks for your help!

joining two tables with record formatting required

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.