RE: [AccessDevelopers] formatting text right in query

Thu, 05 Jan 2006 07:53:55 -0800

Hello

Try this one:

 

SELECT formatnumber(format(40EXC.Retail),2) as Expr1

FROM 40EXC;

 

 

 

From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Fastnet Software
Sent: 5. januar 2006 16:37
To: AccessDevelopers@yahoogroups.com
Subject: RE: [AccessDevelopers] formatting text right in query

 

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.


YAHOO! GROUPS LINKS



Reply via email to