In this example a calculated field is formatted to be exported. INV_SalesTaxAmt: Format([INV_ProjectTotal]* [INV_SalesTaxPer]/100,"0000.00") you need to use the format statement and in double quotes insert the format( amount of digits and decimal postions you need). A.Torres
--- In [email protected], "Fastnet Software" <[EMAIL PROTECTED]> wrote: > > Good day all > Please can someone help with formatting text in a query output/export to a > text file? > Basically I have a field on export (I have set up a spec to get field > spacings correct) which is all aligned left e.g. > 1.00 > 0 > 1999.99 > I need all the fields right aligned if possible. > Have tried format `/3' e.g. align right, but still exports the same. > Hope I have made myself clear. > Tia > Matt t > Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
