RE: [AccessDevelopers] formatting text right in query

[Fastnet Software]

I have now got as far as this SELECT DISTINCTROW Format([Retail],"0000.00") AS Expr1 FROM 40EXC; Which produce 0014.99 for example, Now I need to lose the zeros so that the 14.99 stays right. Any ideas? Thks matt   -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED]On Behalf Of Fastnet Software Sent: 05 January 2006 11:23 To: AccessDevelopers Subject: [AccessDevelopers] formatting text right in query   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. SPONSORED LINKS Microsoft access developer Microsoft access help Microsoft access database Microsoft access training Microsoft access training course Microsoft access programming YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.