Printing Labels using DataReports

I am using DataReports to print labels and have set up the data report to print out 21 labels making it 3 columns of 7 labels...

The problem I am having is instead of each label being individual (what I want) each row is the same as the previous row? I have tried making each label individual by add 'distinct' to the sql statement which bring back the data, anyone help me?

Hi,
can you post sql statement

Regards,
Champgary

Heres my SQL code:

VB Code:

If ShowAllResults = True Then
 
    query = "select distinct Access_NO,ICCID " & _
            "from Test_Dec_Puk_Details tdPD, Test_Dec_GSM_PP_Access_Numbers tdGPAN " & _
            "where ICCID_Full = '" & FileIDToPrint & "' " & _
            "and tdPD.ICCID = Ltrim(tdGPAN.Assoc_Access_No)"
            
Else
 
    query = "select distinct Access_NO,ICCID " & _
            "from Test_Dec_Puk_Details tdPD, Test_Dec_GSM_PP_Access_Numbers tdGPAN " & _
            "where tdPD.ICCID = Ltrim(tdGPAN.Assoc_Access_No) " & _
            "and ICCID_Full = '" & FileIDToPrint & "' " & _
            "and Access_NO >= '" & PhoneNumberFrom & "' " & _
            "and Access_NO <= '" & PhoneNumberTo & "'"
 
End If

????

Moved to reporting section