Search results for query: *

I have a field where I would like to split the string into two fields. The string contains no spaces. The first (L-R)six characters is the postal code and the seventh character is a code#. I would like to split the postal code from the code#. Ex. FIELD1 V0N1Y67 V0N1Y69 V0N2X46 V0N1Y62...

Thank you PHV, The query worked great. I did have to run it overnight even after indexing FIELD1, but it did finally do what I wanted it to. Thanks again for your speedy reply! -H

Hi PHV, I'm currently running the script that you had provided and it's about 1/3 completed after 1.5hrs. Is this typical for a dataset of 170K records?

Hi PHV, The PK field is simply entitled, ID.

Hi Dontremb, Yes, I do want to consolidate Field1 and keep all the fields associated with the particular row. All other duplicate Field1's and their associated records can be deleted. Below is the result that I'm looking for: FIELD1 FIELD2 FIELD3....etc there are 20 fields V0N2J5...

I would like to keep all the fields. I have used Access to auto-generate a PK, but it will be deleted once duplicates (Field1) are removed. It does not matter what duplicate value in Field1 that is retained; I just want to retain one of the duplicate values (Field1) and their associated record.

Hi, I have one table called districts. The table contains 150K+ records. The first field (Field1) contains duplicate data, however their records are still unique. Can anyone help with a script to remove the duplicate field data and associated record and keep one instance of the duplicate data...

Thank you all for your assistance! It really helped me in pinch:) An extra special thank you to JarlH for your script, which worked like a charm. Cheers, HUNGUYEN

To whomever can assist: I am trying to design an SQL statement that will delete the MIN value in one field. I have three fields of interest: Fields: Parcel, Soil_Texture, Area Ex. Parcel #1 is duplicated three times b/c there are three Soil Ttextures and three Area associated with it: i.e...