0 Replies - 810 Views - Last Post: 13 August 2013 - 12:20 AM Rate Topic: -----

#1 sathish_v  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 2
  • Joined: 13-August 13

insert into with wild Search

Posted 13 August 2013 - 12:20 AM

hi All

Using VB6 as front end and MS access as database i am trying to do a wild search on customer address field so my problem is i need to insert the record which has record count <=1500

Below is my code which i used only to Select and insert

gql = "Insert Into out_1 SELECT DISTINCT  MSISDN,CUST_NAME,STATUS,CUST_ZIP,CUST_ADDRESS,total_outstanding,ACCOUNT_NO FROM base where  CUST_ADDRESS like " & "'%" & Text3.Text & "%'  group by MSISDN,CUST_NAME,STATUS,CUST_ADDRESS,CUST_ZIP,total_outstanding,ACCOUNT_NO  "


Can some one help me on code that insert only if record count is <=1500

Is This A Good Question/Topic? 0
  • +

Page 1 of 1