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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ladyhawkfl

  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
See more

Part and Inventory Search

Back
Top