ADO SQL and Recordset HELP!!

[MsAmanda]

Hello All, I am having the most wretched time trying to figure this out. I have a worksheet with merged cells (I cant change the input format, I know, I know merged cells are evil and very true for me right now). But anyway in order to get the data I need I have to run 2 queries which works fine, but I need to either some how redo my queries to get or merge the end record sets so that either way I end up getting the Comments appended to the original data retrieved in the first query so I can then make a table in excel that makes sense and I can work with. Please help someone, Ive spent almost 2 days on this and making me crazy.

Sub TestSQL4()
    Dim strSQL
    Dim fname
    Dim tblheader
    Dim rs As New ADODB.Recordset
    
    fname = "Poam.xls"
    tblheaders = "Yes"
    
    'strSQL01 = "SELECT [CAT], [POC], [IA Control and Impact Code], [Resources Required], [Estimated Completion Date], [Source Identifying Weakness], [Status], [Comments] FROM [PackagePOAM$A13:U160] where [CAT] = 'III'"
    
    strSQL02 = "SELECT [Comments] FROM [PackagePOAM$A13:U160] where [Comments] not Like '%the IAC is NA%'"
   
    RunQuery strSQL, fname, tblheaders, rs
            
End Sub

 

[MsAmanda]

Im getting closer again I need to either find a SQL way to do this or via VBA recordset results the below ADO query/subquery is almost it

Select FirstSelect.Cat, FirstSelect.ID, SecondSelect.Comments From ((Select [CAT] As Cat, [ID] As ID From table1) As FirstSelect (Select [Comments] As Comments From table1 Where [Comment] is not Like '%NA%') As SecondSelect)