RE: [AccessDevelopers] formatting text right in query

Thu, 05 Jan 2006 07:52:20 -0800

Title: Message
Format([Retail],"0.00") will do it, won't lose any digits on the left of the decimal point.
 
Tobi
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Fastnet Software
Sent: Thursday, January 05, 2006 10:37 AM
To: [email protected]
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: [email protected] [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



Reply via email to