Didn't work.

I think the inner grouping, by joining the child,  is also causing some-sort of catesean product. Remeber the child can have multiple record, if your grouping at the parent...

Interestingly enough, I'm off experimenting with 'derived' tables. I have the first part done. I'm taking your snap-shot and seeing how it line's up with what I've got so far.

I...

I need to pick up all codes and descriptions for each user record. So the results would look like

id     codes+desc

1      81.51-desc8151,81.52-desc8152.....

id from tableA, codes+desc from tableB. Because an id...

THATS IT!

Off to do some tests, but I knew I used it somewhere and I even mentioned 'Dynamic' SQL. It was an article right here on Stored Procedures and 'null'...

stay tuned...

David;

Were you listening in? We just discussed this in my team meeting  an hour ago and I'm off running a preview to get signed off, based on max lag!

Validation turned up missing record that should have been included.

ID PART  DOS             POST           LAG   VOL         CHARGES

5  198     03/22/2006  04/03/2007  377   -1.0000    -115.00

5  198     03/22/2006  04/04/2007  378   -1.0000    -115.00

5 ...

I should add -

The ONLY reason for the ThisWorkbook.Open() functions is to restore formating lost in the transformation.

 For Each c In Worksheets("CENSUS").Range("integers").Cells     

       If Len(c.Value) > 0 Then c.Value =...

The task -  OpenExcel Template, populate various ranges, Save as Excel workbook, email.

The problem - When the receipients open the attachment they are first propmpted to enable the macros. If their...

David;

Thanks. I know I read somewhere in SQL book about the left/right side of the join syntax, and took for granted that impacted the parser.

I've made those change and...

David;

Ok, I'm running validations to understand. I've always used 'left join' with the table I want all data from (a) on the left side of the '='  as (a.filed =...

David;

Did you want to Left Join

b , then placing

b on LEFT side of each pair in clause, and still ask when

b is null?I'm not familiar...

Yes, the source table only has little over 400 rows, and the retructuring only needs to be done once a year. The table was also supposed to have unique 'codes', but...

After review -

Original table contained non-unique entries, in error. Obtained correct list and refreshed. Table contains 848 rows. 

Both solutions now retrive identical count & valued rows (157). Only difference is...

Ken, Brian-

Thanks for the replys. Now off to do validation as both answers returned different #rows. Let me compare the two and I'll get back.