I am looking for a way to split a table either before or during an export to a text file. If possible I would like Access to find the mid way point of the file based off a specific field. The field I would like to use is actually generated by a mailing verification software, so it might have a couple thousand entries that say "1" or "2". So in a 100,000 record table I might only have up to number "33" or so. Does anybody know where I would even start to try and accomplish this???

- A form Developer who got roped into Access and VB.