Record 2 is first probably because it's the only one that has a number in that field.
There are some problems with your .db file, though, even before making the changes. Record 1 has 8 fields. Record 2 has 17 fields. Record 3 has 13 fields. It's too hard to count the rest. All of your records must have the same number of fields. Basically, they all need to have the same number of delimter characters. I'm pretty sure the code will work if you fix the records.
You know what, though? I just realized that you don't need to add the delimiter at the end. I'm sorry. I wasn't thinking clearly. The script will add it as it did with the second record.
JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.
There are some problems with your .db file, though, even before making the changes. Record 1 has 8 fields. Record 2 has 17 fields. Record 3 has 13 fields. It's too hard to count the rest. All of your records must have the same number of fields. Basically, they all need to have the same number of delimter characters. I'm pretty sure the code will work if you fix the records.
You know what, though? I just realized that you don't need to add the delimiter at the end. I'm sorry. I wasn't thinking clearly. The script will add it as it did with the second record.
JPD
----------------------------------------------------
JPDeni's DBMan-ual
How to ask questions the smart way.