Printing Labels using DataReports

[JerseyKid]

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?

[CHAMPGARY]

Hi,
can you post sql statement

Regards,
Champgary

[JerseyKid]

Heres my SQL 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

????

[Hack]

Moved to reporting section