Search results for query: *

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.

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!

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

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.

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.

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.

Worked great; thank you!!!!!!

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

Thank you Olaf! Works great!

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?

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

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?

Worked great; thank you!

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