User Profile

Collapse

Profile Sidebar

Collapse
KPoe
KPoe
Last Activity: Mar 26 '08, 08:09 AM
Joined: Mar 19 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • KPoe
    replied to Deleting a similar record
    in SQL Server
    After a bit more searching, I managed to get the following solution.

    First I created another table containing the duplicate fax numbers. The SQL is

    SELECT DISTINCTROW LstFax.REF, LstFax.ADDR INTO LstTmp FROM LstFax LEFT JOIN LstFax AS LstFax_1 ON LstFax.ADDR = LstFax_1.ADDR WHERE (((LstFax.ADDR) In (SELECT [ADDR] FROM [LstFax] As Tmp GROUP BY [ADDR] HAVING Count(*)>1 )) AND ((LstFax.REF)>[LstFax_1].[REF]));...
    See more | Go to post

      Leave a comment:

    • KPoe
      replied to Deleting a similar record
      in SQL Server
      thanks kavitadatar ,

      No such luck. Error 3128 - specify table containing records you want to delete

      I am wondering if I have to go about this a different way?

      KPoe
      See more | Go to post

        Leave a comment:

      • KPoe
        started a topic Deleting a similar record
        in SQL Server

        Deleting a similar record

        Hi,

        I have a simple Access Table (LstFax) with "REF" (Client NAme) and "ADDR" (Fax numbers) fields that has been generated by SQL from a custom query form. There are duplicate fax numbers for clients from the same office that I want to delete.

        I have a sub to try and delete these similar field based on some code I found on the net using From ... From syntax but am having some problems. I can't...
        See more | Go to post
        No activity results to display
        Show More
        Working...