Merge Record from 3 Tables

[tinapa29]

heres the code to query 4 tables (necessary to query all 4 tables)

SELECT * into tblDUPLICATE FROM ((CRIME LEFT JOIN SUSPECTS ON CRIME.CITE_NR = SUSPECTS.CITE_NR) LEFT JOIN OFFENSE ON CRIME.CITE_NR = 

OFFENSE.CITE_NR) LEFT JOIN VICTIMS ON CRIME.CITE_NR = VICTIMS.CITE_NR WHERE (Year([DATE_COMTD])= YEAR(DATE());

heres my code to


MERGE record with the same CITE_NR AND NOT same V_NO
WILL NOT MERGE if same CITE_NR AND SAME V_NO

Do Until BasRecSet.EOF
    Do Until rsMerge.EOF
        SQLScript01 = "SELECT * FROM " & STR4Query & " WHERE CITE_NR like " & Trim(rsMerge!CITE_NR)
        Set strBravo = CurrentDb.OpenRecordset(SQLScript01)
        With strBravo
            If BasRecSet.Updatable Then
                If rsMerge!V_NO <> BasRecSet!V_NO Then
                    BasRecSet.Edit
                    BasRecSet!V_NAME = BasRecSet!V_NAME & ", " & BasRecSet!V_NAME
                    BasRecSet!V_SEX = BasRecSet!V_SEX & ", " & BasRecSet!V_SEX
                    BasRecSet!V_AGE = BasRecSet!V_AGE & ", " & BasRecSet!V_AGE
                    BasRecSet.Update
                ElseIf rsMerge!S_NO  <> BasRecSet!S_NO  Then
                    BasRecSet.Edit
                    BasRecSet!S_NAME = BasRecSet!S_NAME & ", " & BasRecSet!S_NAME 
                    BasRecSet!S_SEX = BasRecSet!S_SEX & ", " & BasRecSet!S_SEX
                    BasRecSet!S_AGE = BasRecSet!S_AGE & ", " & BasRecSet!S_AGE
                    BasRecSet.Update                        
                End If
            Else
                MsgBox "Table Cannot Use for Updating!"
            End If          
        End With
    rsMerge.MoveNext
    Loop
BasRecSet.MoveNext
Loop

but not performing the way i needed the code to

as shown from the screenshots...

[RuralGuy]

When you cross post, please tell readers you have done so and provide the associated link(s).

Here is why!
http://www.utteraccess.com/forum/ind...ic=2041008&hl=

[tinapa29]

When you cross post, please tell readers you have done so and provide the associated link(s).

Here is why!
http://www.utteraccess.com/forum/ind...ic=2041008&hl=

an honest mistake on my part since i'm really in dire need of help nonetheless, i apologize for the said incident...
but would really appreciate if someone could provide me thanks....