Problem Exporting data as fixed width

[dakcg]

Hi all,

I have to export data from various access tables out as .dat files for importing into ADP Benefit Services system. I can get the records out table by table and then manually unite them in the .dat file, but that is not how they want the data. I need to get the records out of all tables by combining all that match using various fields (Social Security #, Dependent #). And to make matters worse, some have only 1 Depentent record and some have more than one record.

Does this make sense to anyone, and can you help! I have never done anything like this before, but I was wondering if there is a way to "loop" to get the records.

Thanks

dakcg

 

[llkhoutx]

Try using the Format statement in a query to get the data in the format you want and then, export that query.