fixed width qry export to text - columns not working

[arpeggione]

Hi: I am exporting an Access 2003 qry to a fixed width text file. One column is 40 max characters wide (some records are 10 characters - some 35, etc for this column). What I've found is that as this column varies, the starting point of the next column also varies - so the fixed width isn't working. My columns in the Export Spec (Fixed Width) are as follows:

Field Name Start Width
MID 1 9
ASSY 10 4
Description 14 40
Qty 54 5
UOM 59 2

I have also tried this using a loop, fixed width variables and writing to a text file, but end up with the same problem. Can anyone help? Thank you in advance...

Karen

 

[dhookom]

You might want to create a query with a single field like:
Left([MID] & Space(9),9) & Left(ASSY & Space(4),4)....


Duane
Hook'D on Access
MS Access MVP

 

[arpeggione]

Duane: Thx for your msg. I will try this out and get back. It may be a few days...Cheers, Karen