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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ladyhawkfl

    Consolidate multiple fields per record to multiple records with 1 field

    Griff, I used your first solution and it worked perfectly. thank you so very much!!!
  2. ladyhawkfl

    Consolidate multiple fields per record to multiple records with 1 field

    I have a table with 1280 records and 208 fields. I need to keep the first 3 fields, (field names: a, b, a0001) for all records. I then need to take all the records where the next field a0002 is populated and replace field a0001 with field a0002 and append fields a, b, a0001 to the file. I know...
  3. ladyhawkfl

    Multiple nth based on count of one field in table

    Randomly. Sorry.
  4. ladyhawkfl

    Multiple nth based on count of one field in table

    I need to randomly nth each zip5 to the desired quantity.
  5. ladyhawkfl

    Multiple nth based on count of one field in table

    Sorry for being so vague. I have a distinct count for each zip5 value from my main file. My associate has provided me with a count of the records she wants for each zip5, which means I need to randomly nth each group of records with a zip5 value to her requested quantity so that I will only...
  6. ladyhawkfl

    Multiple nth based on count of one field in table

    I have a table of 25,000 records and need to nth based on zip5 field with variable quantities per zip5. I've run a select distinct to provide the actual quantities per zip5, but need to nth each group with a unique nth value for each. Any suggestions, for the nthing, other than running each...
  7. ladyhawkfl

    Ascii Characters in a field

    Thanks to all who replied! Ultimately, I was able to solve the dilemma - It was ASCII code 127 / Hex 7F that was causing all my problems! Thanks again! Pam
  8. ladyhawkfl

    Ascii Characters in a field

    Thanks, but it didn't work! I have tried every ASCII conversion code that I can think of and none work. Thanks for the idea!
  9. ladyhawkfl

    Ascii Characters in a field

    I am attempting to remove Ascii bar characters from a name field and have not been successful. The file was exported from Access into DBIII format and contains the ASCII bar characters for a TAB. Any suggestions would be very much appreciated. Pam

Part and Inventory Search

Back
Top