Re: Unique Records in table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: raywhartman (raywhartman_at_earthlink.net)
Date: 08/19/04

  • Next message: Marko Andreis: "Re: recordset problem with SQL" 
    Date: Thu, 19 Aug 2004 19:47:06 GMT

    try something like this
    select * from yourtable group by field1, field2,field4 field4 into table
    newtable

    "mattcatmattcat" <mbd_20002000@yahoo.com> wrote in message
    news:70B777F1-0E1A-4DD4-A676-D1F9019A4B3D@microsoft.com...
    > Heres my dilema I hope someone can help me with.
    > I have a table with 10 Fields. For of the fields are company, address1,
    city
    > and zip and there are six others. There are many records that have the
    same
    > data for the mentioned fields but i need to create a new table with the
    data
    > from this table but if there are duplicates based on the fields I named,
    only
    > one of them goes into the new table. Any one have any suggestions on how I
    > should do this?

  • Next message: Marko Andreis: "Re: recordset problem with SQL"