background
1.) i have created a program (PackingSlip.mdb, just for laughs) in access 2000 that allows me to import text comma delimited, quote bound text files and create packing slips, before the necessary information is sent to our shipping system. the program has not gotten heavy use yet, but the limited action it has seen, it has been successful 100% of the time.
2.) at the behest of one of our clients, i created another access 2000 program (export.mdb, for a couple more laughs) that she could use to create the file from a fixed width file that is created by her system. it involves using the import file wizard with some pre-set "specs". the end result is a comma delimited, quote bound text file with the correct number of fields.
problem
when i import the file created by export.mdb into PackingSlip.mdb, everything appears fine. however, when i open the query that sends all pertinent information to my various packing slips, there is nothing in it. when i check the tables where the query is getting it's information from, they have all of the correct data in them. i would post code here, but i have no idea where to start.
sincerely,
one-very-frustrated-and-seemingly-perpetual-newbie
