Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Split data in a field
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...- Hunguyen
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
-
Access: Remove similar records with one duplicate field
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...- Hunguyen
- Thread
- Replies: 12
- Forum: Microsoft: Access Queries and JET SQL
-
Querying out the largest value?
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...
