Heres my SQL code:

VB Code:
  1. If ShowAllResults = True Then

  2.  
  3.     query = "select distinct Access_NO,ICCID " & _

  4.             "from Test_Dec_Puk_Details tdPD, Test_Dec_GSM_PP_Access_Numbers tdGPAN " & _

  5.             "where ICCID_Full = '" & FileIDToPrint & "' " & _

  6.             "and tdPD.ICCID = Ltrim(tdGPAN.Assoc_Access_No)"

  7.             

  8. Else

  9.  
  10.     query = "select distinct Access_NO,ICCID " & _

  11.             "from Test_Dec_Puk_Details tdPD, Test_Dec_GSM_PP_Access_Numbers tdGPAN " & _

  12.             "where tdPD.ICCID = Ltrim(tdGPAN.Assoc_Access_No) " & _

  13.             "and ICCID_Full = '" & FileIDToPrint & "' " & _

  14.             "and Access_NO >= '" & PhoneNumberFrom & "' " & _

  15.             "and Access_NO <= '" & PhoneNumberTo & "'"

  16.  
  17. End If

????