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 Rhinorhino 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. pkdata

    Assign Sequential number based on field value

    Olaf, thank you so much for all the thought and effort you gave to help! One note, I agree with you ref the sub counter field, however, once all campaign files were concatenated, client came back requesting this be added for tracking purposes. Again, thank you very much.
  2. pkdata

    Assign Sequential number based on field value

    This works great; thank you. Sorry for not getting back to you all sooner, was in meetings all day yesterday and this morning. Hope everyone has a great day!
  3. pkdata

    Assign Sequential number based on field value

    Thanks Olaf, but still didn't work. Might have to rethink process.
  4. pkdata

    Assign Sequential number based on field value

    Thanks again Mike. Using code in your second reply, if ID field set to integer, all records are populated with 1. If ID field set to numeric, standard RECNO() for entire file is populated.
  5. pkdata

    Assign Sequential number based on field value

    Thanks Mike, but that assigns the record number for each record in the entire file without looking at the campaign value. I need the recno() assigned uniquely for each campaign; I will end up with 84 records with a recno() of 1, for example.
  6. pkdata

    Assign Sequential number based on field value

    I have a master file of 2.3mm records containing 84 unique "campaigns" and I need to assign a sequential RECNO() for each record of each campaign. Any help is greatly appreciated.
  7. pkdata

    Have a challenge

    Worked great; thank you!!!!!!
  8. pkdata

    Have a challenge

    I have 2 tables. One with full zipcodes. The other with an assigned 2 digit character with a zip5 and specific ranges of zip4's. Example: Table 1 titled Work contains zip 20171-1512 Table 2 titled Districts contains a zip4 range for each assigned store. zip5=20171 zip4 start=1000 zip4...
  9. pkdata

    Multiple nths within one table

    Thank you Olaf! Works great!
  10. pkdata

    Multiple nths within one table

    You know, it seems as if I recall assigning a sequential number for each value and then deleting anything greater than 10. Does that sound like it would work?
  11. pkdata

    Multiple nths within one table

    I have as many as 30 records with the same value in the dg field and I only need ten records for each group where the value is the same. Example: 27 records have a dg value of 1234 and I only want to retain 10 of those records 12 records have a dg value of 5678 and again, I only want...
  12. pkdata

    Multiple nths within one table

    I have a table of 128k+ records and need to nth out based on values in one field called "dg". I need to nth to 10 records per value in the column dg. Any suggestions?
  13. pkdata

    Scan not working

    Worked great; thank you!
  14. pkdata

    Scan not working

    Don't know if anyone can help me out here. I have a table with 30 fields, one of which is a numeric field. This field is not populated for every record in the table and I need to copy the value of this field for next ? quantity of records until the numeric field is populated again. Example...

Part and Inventory Search

Back
Top