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!

Search results for query: *

  • Users: ladyhawkfl
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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